> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]