t_machine Posted March 28, 2009 Share Posted March 28, 2009 hi, I hope someone can help with this problem. I am trying to search a table and only display results if search does not exist in another table. For example. Search table 1 for users with the name "test", get the id for that user then check Table 2 if that user id exists. If it does not exist then show results. I assume a good join would work or a sub query but I do not know where to begin. Any help would be greatly appreciated. Quote Link to comment https://forums.phpfreaks.com/topic/151517-how-to-search-one-table-then-show-results-if-not-exists-in-another/ Share on other sites More sharing options...
fenway Posted April 1, 2009 Share Posted April 1, 2009 a LEFT JOIN? Quote Link to comment https://forums.phpfreaks.com/topic/151517-how-to-search-one-table-then-show-results-if-not-exists-in-another/#findComment-798566 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.