General discussion
February 12, 2003 at 02:53 AM
c.stansbury

I need help with a subquery!

by c.stansbury . Updated 23 years, 7 months ago

Change this into a subquery
SELECT a.slname as LastName, a.sfname as FirstName, b.cname as CoureTitle, c.grade as Grade
FROM banerjee.student a, banerjee.course b, banerjee.enrollment c, banerjee.course_section d
WHERE c.grade is NOT NULL
AND a.sid = c.sid
AND c.csecid = d.csecid
AND d.cid = b.cid;

This discussion is locked

All Comments