471,327 Members | 2,139 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,327 software developers and data experts.

searching through tables

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
Dec 8 '05 #1
2 908
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

Dec 8 '05 #2
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

Dec 8 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Michi | last post: by
3 posts views Thread by aaj | last post: by
1 post views Thread by Robert Oschler | last post: by
33 posts views Thread by Geoff Jones | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.