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.

 

[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,