[thelist] mysql question

[Simon Lee]

> 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?
>
Yes and No Kevin.

The following SQL string would work...

$sql = "
	select item_id from tableA WHERE item_review='$search_term'
	UNION
	select item_id from tableB WHERE description='$search_term'
";

BUT...one of the many 'features' of MySQL is that it doesn't support the
UNION construct, so you'll have to create a temporary table to return
the results, or run separate queries.....or use another db e.g.
PostgreSQL, Oracle, etc.

HTH
sl