mbeals Posted December 11, 2007 Share Posted December 11, 2007 I have two tables that I am using joins to compare. It works great for combining the two and giving me the common values, but I am also interested in what is not matching. Is there a query that I can run that will basically do a left join and only return the entries that did not match or am I going to have to pull the entire results field in and process it line by line with php, looking for empty values? Quote Link to comment Share on other sites More sharing options...
fenway Posted December 12, 2007 Share Posted December 12, 2007 A LEFT JOIN? Quote Link to comment 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.