Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Luinearan
Starting Member
3 Posts |
 Posted - 2007-10-24 : 22:19:47
|
| I have been working on a database and I have imported a number of lists into multiple tables. I am having a lot of trouble writing the SQL code to be able to query across multiple tables. For instance, I want to know if john doe is on all five lists or if he is only on 3 lists (search by student name).Can someone help me with this?Luin. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-26 : 02:56:44
|
| You could use a UNIONJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
Search for items across multiple table...