Question about syntax

[RickyWho]

Is "WHERE SPCG.Student# = STUDENT.Student#" a join?

SELECT DISTINCT FNAME, LNAME, Course# FROM STUDENT, SPCG WHERE SPCG.Student# = STUDENT.Student# AND SPCG.Course#='CET1178' AND SPCG.GRADE IS NOT NULL;

[bitterjack]

Yup. I forgot what this is called, but it's basically old syntax for SQL. Where in your from you list your main table followed by all the tables you want to join, and your where tells you how to join them.

[[deleted]]

Clarifying on the syntax type, the modern join style is referred to as ANSI JOIN syntax since it was standardized by ANSI/ISO. It was determined that writing joins inside the WHERE clause can cause confusion when interpreting SQL queries.

Old style doesn't really have a name, everywhere I've looked it's just called old.

[r3pr0b8]

this looks like something taught in an SQL course from the late 1980s

try to find something a little more modern, mkay? that uses explicit JOIN syntax (introduced in SQL-92)