Re: searching through tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

SELECT table1.columnName As name FROM table1
UNION SELECT table2.columName As name FROM table2
UNION SELECT table3.columnName As name FROM table3

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
You can lead a fish to a bicycle,
but you can't make it stink.

"Hrvoje Voda" <hrvoje.voda@xxxxxxxxxxx> wrote in message
news:dn92nb$45e$1@xxxxxxxxxxxxxxxxx
> Is there a way to search for a specific item through a various number of
> tables?
>
> I want to find out , for example, if there is a name of user in some of
> three tables in database.
>
> Hrcko
>


.

Relevant Pages

  • Re: VS 2005 LoaderLock problem
    ... >> Microsoft MVP ... >> .Net Developer ... >> You can lead a fish to a bicycle, ...
    (microsoft.public.dotnet.framework)
  • Re: possible java script question
    ... and the bicycle has to *want* to change. ... >> Microsoft MVP ... >> ..Net Developer ... >> You can lead a fish to a bicycle, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: XML Deserialization
    ... Microsoft MVP ... ..Net Developer ... You can lead a fish to a bicycle, ... and the bicycle has to *want* to change. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Visual Studio is Busy
    ... and the bicycle has to *want* to change. ... > baloon will popup in the lower right corner of the screen saying "Visual ... >> Microsoft MVP ... >> ..Net Developer ...
    (microsoft.public.vsnet.general)
  • Re: Microsoft JET database error while trying to open excel file from ASP.NET
    ... Microsoft MVP ... ..Net Developer ... You can lead a fish to a bicycle, ... and the bicycle has to *want* to change. ...
    (microsoft.public.dotnet.framework.aspnet)