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 |
|
genic
Yak Posting Veteran
57 Posts |
 Posted - 2001-02-19 : 13:10:16
|
| i am trying to do the following.i have two tables. one is profile ..the other is projecttime. based on a form selection i want to use the values and select all the profileemail(s) within profile. then use those values to select the records within projecttime. to select from profile i do the following:select profileemail from profilewhere profile_org = '1' and profile_dept = '6' and profile_team = '3_6'now, this will retrieve FOUR records. i need to query based upon those four records. i need to do something like this..this will pull out the hours in the projecttime table for EACH of the profileemails that i have found. i can do the first one just fine...but it ignores the other ones it finds after the first one.select profileemail, hours from projecttime where profileemail ='theemailsthatihavefound'is there a way to do this nested in all one sql statement? if there is and i can get all the records in one recordset, that would be great. your help is appreciated. |
|
|
|
|
|
nested SQL within ASP