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. 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? 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
Archived
This topic is now archived and is closed to further replies.