A表
id datetime
1 2009-1-1
2 2009-1-2Detail表
id Aid datetime
1 1
2 1
3 2
4 2
5 2我要用A表的datetime更新Detail表的datetime,条件是Detail.Aid=A.id
结果是这样
Detail表
id Aid datetime
1 1 2009-1-1
2 1 2009-1-1
3 2 2009-1-2
4 2 2009-1-2
5 2 2009-1-2
id datetime
1 2009-1-1
2 2009-1-2Detail表
id Aid datetime
1 1
2 1
3 2
4 2
5 2我要用A表的datetime更新Detail表的datetime,条件是Detail.Aid=A.id
结果是这样
Detail表
id Aid datetime
1 1 2009-1-1
2 1 2009-1-1
3 2 2009-1-2
4 2 2009-1-2
5 2 2009-1-2
update Detail
set [datetime]=a.[datetime]
from Detail b,A a
where b.Aid=a.id
Detail
set
[datetime]=a.[datetime]
from
a ,Detail b,
where
b.Aid=a.id
set [datetime]=a.[datetime]
from A
where Aid=Detail.id