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