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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-11 : 10:36:12
|
| Jan writes "Hi,First, thanks for taking the time in helping me. I'm trying to gather all the user's information they have enrolled for individual or/and group package they have enrolled. I have two tables. One table holds individual entitlements for enrollment, and the other holds packages of enrollment. A user can have group package(s) enrollment and also add on individual entitlements if they don't wish to purchase a whole package. The individual table1:useridentitlementgrantdateexpiredatebillIn order to access the group pkg table2, I have to link with a user_class table3 to get the userids:group pkg table2class_idgrantdateexpiredatebilluser_class table3class_iduseridgrantdateexpiredateThis table (user_info) is where I must link to get the user's personal information: user_info table4useridfirstnamelastnameThanks again for your help. I'm really stuck here. Jan" |
|
|
|
|
|
Three Subqueries? can i combine two separate queries to produce one result?