| Help..URGENT !! [message #371737] |
Thu, 30 November 2000 21:18  |
Alex
Messages: 190
Registered: August 1999
|
Senior Member |
|
|
Hi,
I need to select the ssn# of the students who have taken all the available courses that are in Course table.
Course table has course_id and course_description. Student table has ssn#, course_id.
Thanx in advance..
..Alex
|
|
|
|
| Re: Help..URGENT !! [message #371741 is a reply to message #371737] |
Fri, 01 December 2000 03:15  |
John R
Messages: 156
Registered: March 2000
|
Senior Member |
|
|
I think this will do it, but our databases are down at the moment, so I can't check
Select s.ssn#
from student s
having count(distinct s.course_id) = (select count(distinct course_id) from course)
group by s.ssn#
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
