| How to write this sql? [message #80682] |
Thu, 31 October 2002 06:53  |
Fico
Messages: 26
Registered: July 2002
|
Junior Member |
|
|
Table1:
ID,Field1,field2
1,aaaa1,bbbb1
2,aaaa2,bbbb2
3,aaaa3,bbbb3
Table2:
ID,Field1,Field2
2,xxxxx,yyyyy
3,zzzzz,sssss
How to update table1 with table2 , if ID not match then keep old value.
after update:
Table1:
1,aaaa1,bbbb1
2,xxxxx,yyyyy
3,zzzzz,sssss
Can I do this?
update table1 a
set (field1,field2)=
(
select b.field1,b.field2
from table2 b
where a.id=b.id
)
Run this sql,Table1 record 1 value is null.
Thanks.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
