根据B表的数据更新A表的内容

[牙签是竹子的]

A表字段 AID,NAME,DATE,SEX，FLAG
B表字段 BID,NAME,DATE,SEX,...

要求：根据B表中的内容,如果B.NAME,B.DATE,B.SEX 这3个字段与A表中的相同，则将A表中的FLAG设为Y

UPDATE A SET FLAG='Y' WHERE 条件

条件那个地方怎么写？

[饮水需思源]

UPDATE A SET A.FLAG='Y'
FROM A,B
WHERE A.NAME=B.NAME AND A.DATE=B.DATE AND A.SEX=B.SEX

[ws_hgo]

update A from A,B SET FLAG='Y' where B.NAME=A.Name and B.DATE=A.DATE and B.SEX=A.SEX

[jwdream2008]

DATE A SET A.FLAG='Y' 
FROM A,B 
WHERE A.NAME=B.NAME AND A.DATE=B.DATE AND A.SEX=B.SEX 

[feixianxxx]

UPDATE A SET FLAG='Y'
from b 
 WHERE b.name=name and b.sex = sex and b.date= date

[Mr_Nice]

update A
set flag = 'Y'
from (select BID,NAME,DATE,SEX from B) T
where A.name = T.name and A.date = B.date and A.sex = T.sex

[ws_hgo]

好快就结贴啦