[thelist] mysql question

Kevin lists at irubin.com
Wed Oct 16 12:31:01 CDT 2002


I have a certain search that I need to perform that searches for items in
multiple tables. How would I combine the following query

select item_id from tableA WHERE item_review='$search_term';

select item_id from tableB WHERE description='$search_term';

Can these be combined to return results from both tables?



More information about the thelist mailing list