searching through tables

[Hrvoje Voda]

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

[Kevin Spencer]

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" <hr*********@luatech.com> wrote in message
news:dn**********@ss405.t-com.hr...

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

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

I assume you mean tables in a dataset, if so you can create a DataView and
set the rowFilter to the correct expression

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Hrvoje Voda" <hr*********@luatech.com> wrote in message
news:dn**********@ss405.t-com.hr...

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