帮忙写条SQL语句

[fidt982]

数据的插入
表A(A1,A2,A3) ----char()
(11,12,13)
(22,22,23)
(33,32,23)

表AA(A1,B2,C3,B3) ----char()
(11,12,13,13)
(22,22,23,23)
(33,32,23,23)
(44,32,23,23)
(55,32,23,23)

表A 或 表AA 字段
根据 A1关联

把表A 中没有 表AA中有的数据(A1,B2,C3)插入到 表A中去。

结果
表A(A1,A2,A3)
(11,12,13)
(22,22,23)
(33,32,23)
(44,32,23)
(55,32,23)

//----------------
这条SQL语句应该怎么样写啊

[fengfangfang]

Insert into 表A
select A1,B2,C3 from 表AA
where EXISTS (select A1,A2,A3 from 表A)

[hsj20041004]

insert into A select A1,B2,C3 from AA
where not exists(select * from A where A1=AA.A1)

[fengfangfang]

Insert into 表A
select A1,B2,C3 from 表AA
where not EXISTS (select A1,A2,A3 from 表A)

[duanduan1122]

insert A
select A1,B2,C3
from AA
where A1 not in (select A1 from A)

[fidt982]

速度真够快,谢了,