General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>from studentcourse left join instructor on studentcourse.instructorid = instructor.instructorid,;
>courseprogram left join program on courseprogram.programid = program.programid;
>where courseprogram.courseid = studentcourse.courseid;
Here you are making two of your joins using ANSI SQL-92 JOIN syntax, and one using the old-fashioned WHERE join syntax. That is not wrong, but may be confusing, and may be related to any incorrect results you are seeing. I, for one, get easily confused when trying to join three tables, and like to use strict JOIN syntax, without nested joins.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only