On Tue, July 31, 2007 8:52, David Ruggles said: > 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 [EMAIL PROTECTED] > Possibly use a union? I think more details would help.
------- William R. Mussatto, Senior Systems Engineer http://www.csz.com Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]