Finding a value in multiple tables

I need to find a userid across several different tables.

What is the best way to do this?

For example I have three tables
TableA
TableB
TableC

They all have a field "id"

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

Thanks,

David Ruggles
CCNA MCSE (NT) CNA A+

Network Engineer	Safe Data, Inc.
(910) 285-7200	david@safedatausa.com

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com