RE: Finding a value in multiple tables

[Chris Boget]

> I want to find the value 123 in the field "id" in any one of these
tables.

SELECT id FROM TableA WHERE id = 123
UNION
SELECT id FROM TableB WHERE id = 123
UNION 
SELECT id FROM TableC WHERE id = 123

Please note that UNION requires that the same number (and type?) of
fields be selected from each table.

thnx,
Chris