admin
05-28-2003, 11:12 PM
You can use Unions to select from two different tables with the same fields.
SELECT * from table1 WHERE description LIKE '%Test%'
UNION
SELECT * from table2 WHERE description LIKE '%Test%'
SELECT * from table1 WHERE description LIKE '%Test%'
UNION
SELECT * from table2 WHERE description LIKE '%Test%'