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 |
newbie2006
Starting Member
7 Posts |
Posted - 2006-06-24 : 02:47:02
|
Hi i have 2 columns in the same table.....one column retrieves all registered students, the other column retrieved registered students but who have not completed a required survey. The 2 sql statements are almost the same except that the 2nd one does another comparison at another table....(i.e. where student_id not in (select student_id from other_t).I am trying to combine the 2 sql statements into a derived table where results will be displayed as follows:registered students | students(incomplete surveys) studA, studB, studC | studBstudC, studD, studE | studD, studEis there any way to do it? |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|