aeroswat Posted March 9, 2010 Share Posted March 9, 2010 Is there something that does what OUTER JOIN does but minus what's in INNER JOIN? I want to be able to get all of the results that don't match anything at all and only those results. Quote Link to comment https://forums.phpfreaks.com/topic/194691-sql-join/ Share on other sites More sharing options...
fenway Posted March 15, 2010 Share Posted March 15, 2010 You mean LEFT JOIN? Quote Link to comment https://forums.phpfreaks.com/topic/194691-sql-join/#findComment-1026470 Share on other sites More sharing options...
aeroswat Posted March 15, 2010 Author Share Posted March 15, 2010 You mean LEFT JOIN? Well LEFT JOIN displays everything. I figured a way to do what I wanted anyways. I just through a WHERE field IS NULL in there with my LEFT JOIN. I figured there might be a way to just pull out all non-matching fields with only some sort of JOIN. Thanks tho Quote Link to comment https://forums.phpfreaks.com/topic/194691-sql-join/#findComment-1026523 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.