Thread: Insert data from tableA into TableB if idA is not already in tableB?
View Single Post
  #2 (permalink)  
Old 05-24-2006, 12:00 AM
alexfr alexfr is offline
Junior Member
  
Join Date: May 2006
Posts: 24
alexfr is on a distinguished road
Default SQL 92 answer. Re: Insert data from tableA into TableB if idA is not already in tableB?
[sql]INSERT INTO tableB (idB, nomB)
SELECT idA, nomA FROM tableA
WHERE NOT EXISTS (
SELECT idB FROM tableB
WHERE tableB.idB = tableA.idA
)[/sql]
Reply With Quote