List:General Discussion« Previous MessageNext Message »
From:David Ruggles Date:July 31 2007 4:02pm
Subject:RE: Finding a value in multiple tables
View as plain text  
It might have been a dumb question, but I really wasn't sure where to start.
Union does exactly what I need! Thanks a bunch.

Thanks,

David Ruggles
CCNA MCSE (NT) CNA A+
Network Engineer	Safe Data, Inc.
(910) 285-7200	david@stripped



-----Original Message-----
From: Wm Mussatto [mailto:mussatto@stripped] 
Sent: Tuesday, July 31, 2007 11:56 AM
To: mysql@stripped
Subject: Re: Finding a value in multiple tables


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	david@stripped
>
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/mysql?unsub=1



Thread
Finding a value in multiple tablesDavid Ruggles31 Jul
  • Re: Finding a value in multiple tablesWm Mussatto31 Jul
  • RE: Finding a value in multiple tablesChris Boget31 Jul
RE: Finding a value in multiple tablesDavid Ruggles31 Jul