[thelist] mysql question

[Kevin]

Hello,

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?

TIA.

--Kevin