SQL Joins syntax

[Rajiv KumarRai]

Hi,

I wish to know whether the SQL Joins syntax has changed for the latest versions of Oracle database?

I was reading SQL from an Oracle 9i book and there SQL Joins syntax was without any clauses or keywords

but in w3schools SQL tutorial specific keywords like INNER JOIN, etc are being used.

Hence please tell me which syntax I should follow.

Thanks

[Roel De Nijs]

I always use this syntax:SELECT col1a, col1b, col2a, col2b, col2c FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.t1_id

[chris webster]

Here are examples of join syntax in Oracle 12c.

Because I learned Oracle many years ago and have mostly worked on dedicated Oracle platforms, I still tend to use the Oracle-style syntax e.g.

SELECT last_name, job_id, departments.department_id, department_name
  FROM employees, departments
 WHERE employees.department_id = departments.department_id

But the standard "INNER JOIN..." syntax works on Oracle as well, as in Roel's example.

PS: I like the way Oracle helps us keep track of industry buzzwords. Oracle 8i/9i were about "i for internet". 10g and 11g were about "g for grid", and 12c is "c for cloud". Very handy!