求sql语句

[blackwh]

table a : aa ,bb ,cc ,dd,...
table b : aa ,bb ,ca ,da....

删除：要删除table a中a.aa = b.aa and a.bb = b.bb的记录

更新：要更新table a中a.aa = b.aa and a.bb = b.bb的记录的任意字段

[andyzq]

delete
from a
where a.aa in (select a.aa
from a, b
where a.aa = b.aa and a.bb = b.bb)

2.更新成什么值？说具体点

[andyzq]

1.或者
delete a
from a, b
where a.aa = b.aa and a.bb = b.bb

[andyzq]

2.

update a
set aa = '你', bb = '好', cc = '吗', dd = '?'
from a, b
where a.aa = b.aa and a.bb = b.bb

[Thinkinger]

2或者：
update a
set aa = '你', bb = '好', cc = '吗', dd = '?'
from b
where a.aa = b.aa and a.bb = b.bb 这样更清晰！

[blackwh]

thanks

[tchatcha]

delete a
from a, b
where a.aa = b.aa and a.bb = b.bb

update a
set aa = '你', bb = '好', cc = '吗', dd = '?'
from a, b
where a.aa = b.aa and a.bb = b.bb

[愉快的登山者]

删除：
delete a from b where a.aa = b.aa and a.bb = b.bb

更新：
update a set cc = b.ca, dd = b.da ......
from b where a.aa = b.aa and a.bb = b.bb