两个表中记录的移动

[linzhengqun]

有表A和B，
A和B都有字段A1（主键），A2；
现想将表B的一条记录移到表A，然后表B删除该记录。
怎么做

[lovcal]

select A1,A2 into B from A
delete from B where A1=你的记录PK

[-狙击手-]

select A1,A2 into B from A where ....
delete from B where .....

[QQMagicer]

select A1,A2 into A from B where B.A1 = 条件

delete from B where A1= 条件