Thread: Any SQL gurus in the house? Can you help?
View Single Post
Old 09-24-2008, 10:17 PM  
Owen Pierce
Registered User
 
Owen Pierce's Avatar
 
Join Date: Dec 2007
Posts: 95
Quote:
Originally Posted by sarettah View Post
INSERT INTO db2 SELECT * FROM db1 WHERE id NOT IN (SELECT id FROM db2)
sub-selects? YIKES!
Owen Pierce is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote