[thelist] mysql question

[Kevin]

> Sent: Wednesday, October 16, 2002 12:36 PM

> > Can these be combined to return results from both tables?
>
> select item_id from tableA WHERE item_review='$search_term';
> union
> select item_id from tableB WHERE description='$search_term';

Is there an alternative that can be used for mysql 3.x

Thanks.