Thread: WTH is wrong with this MySql statement?
View Single Post
Old 10-18-2006, 10:37 AM  
CaptainHowdy
Too lazy to set a custom title
 
Industry Role:
Join Date: Dec 2004
Location: Happy in the dark.
Posts: 94,196
Quote:
Originally Posted by psili View Post
You could try:

SELECT id FROM table1 LEFT JOIN table2 WHERE table2.id IS NULL
!!
__________________
Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted

Windows VPS now available
Great for TSS, Nifty Stats, remote work, virtual assistants, etc.
CaptainHowdy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote