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 |
|
zippy
Yak Posting Veteran
69 Posts |
 Posted - 2001-10-13 : 18:27:11
|
| Hi,I have 2 tables.One contains details about different people.the second is a list of results for anygiven day.I am writing a query which will produce results for the last week.What I have come up with is a query which returns the name of the person from the first table, and then the results for each day are built from 7 sub queries.The problem I have is that I need the subquery to have a where clause which is = to the id# that the main query is on (it will return multiple rows)is this possible?does that make sense?anyone have any ideas?thanks :)Check out the worlds fastest computers at http://www.ocgurus.com |
|
|
|
|
|
Subqueries