Thread: Any SQL gurus in the house? Can you help?
View Single Post
Old 09-25-2008, 05:53 AM  
sarettah
see you later, I'm gone
 
Industry Role:
Join Date: Oct 2002
Posts: 14,214
Quote:
INSERT INTO db2 SELECT * FROM db1 WHERE id NOT IN (SELECT id FROM db2)
Quote:
Originally Posted by Owen Pierce View Post
sub-selects? YIKES!

Yep. Pretty quick, simple and straight forward.

And your issue with sub-selects is ??
__________________
All cookies cleared!
sarettah is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote