You can express this using JOIN
as:
insert into Buy99
select vb.*
from ViewBuy99 vb left join
Buy99 b
on b.id = vb.id
where b.id is null;
However, I would recommend NOT EXISTS
:
insert into Buy99
select vb.*
from ViewBuy99 vb
where not exists (select 1
from Buy99 b
where b.id = vb.id
);
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…