Code Forums - View Single Post

sde · 11-14-2005, 07:49 PM

fun, 3 tables

Code:

SELECT student.fname, student.lname from student
  LEFT JOIN registration on student.sid=registration.sid
  LEFT JOIN faculty on registration.iid=faculty.instructor_id
  WHERE faculty.fname='dumbledore'

11-14-2005, 07:49 PM	#4 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,529	fun, 3 tables Code: SELECT student.fname, student.lname from student LEFT JOIN registration on student.sid=registration.sid LEFT JOIN faculty on registration.iid=faculty.instructor_id WHERE faculty.fname='dumbledore'