ueon Posted October 21, 2011 Share Posted October 21, 2011 How do I search through table 1, 2, 3 where a=x and b=y and c=z? Quote Link to comment https://forums.phpfreaks.com/topic/249497-search-multiple-tables-at-once/ Share on other sites More sharing options...
jushiro Posted October 21, 2011 Share Posted October 21, 2011 Are you using SQL?.. Try this. SELECT * FROM 1 , 2 , 3 Where A='x' AND B='y' AND C='z' Quote Link to comment https://forums.phpfreaks.com/topic/249497-search-multiple-tables-at-once/#findComment-1280996 Share on other sites More sharing options...
ueon Posted October 21, 2011 Author Share Posted October 21, 2011 would it work even if a belongs to table 1, b to 2 and c to 3? Quote Link to comment https://forums.phpfreaks.com/topic/249497-search-multiple-tables-at-once/#findComment-1280999 Share on other sites More sharing options...
ManiacDan Posted October 21, 2011 Share Posted October 21, 2011 Is there anything that connects these three tables? If the tables have absolutely nothing in common (no unifying structure, no similar columns, nothing in common) then three queries would probably be best. Quote Link to comment https://forums.phpfreaks.com/topic/249497-search-multiple-tables-at-once/#findComment-1281010 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.