sql查询一个表里的数据在另一个表是否存在

sql查询一个表里的数据在另一个表是否存在,如果不存在就写入这个表，存在就不写，用SQL完成怎么写

---

insert into tableA
select * from tableB b where not exists(select 1 from tableA a where a.id = b.id)
insert into tableA
select * from tableB b
left join tableA a on a.id = b.id
where a.id is null
----用 not exists来判断,left join ，消绝其中条件拿纤姿为唯竖友一性主键

---

--创建测试燃缺此表
CREATE TABLE AA_TMP(ID VARCHAR2(10)); --插入目标表
CREATE TABLE AA_LOOKUP(ID VARCHAR2(10));--要插入的数据

INSERT INTO AA_LOOKUP VALUES('1');
INSERT INTO AA_LOOKUP VALUES('皮迅2'扮空);
INSERT INTO AA_LOOKUP VALUES('3');
COMMIT;

--插入数据不存在时更新
INSERT INTO AA_TMP(ID)
SELECT ID FROM AA_LOOKUP A
WHERE NOT EXISTS
(SELECT 1 FROM AA_TMP B
WHERE A.ID=B.ID
)
;
COMMIT;

---

1先判断是否存桥银在孙消歼
if exists(select * from 表则冲名where 字段not in '数据')
insert添加

---

select * from swdj where qymc not in (select qymc from gsdj)