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. 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? 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 Link to comment https://forums.phpfreaks.com/topic/194691-sql-join/#findComment-1026523 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.