SQL Multi-Table View Joins

Asked Dec 13 '16 at 14:15

Active Dec 13 '16 at 14:15

Viewed 33 times

I'm a noobie with SQL and have a syntax problem about multi-table joins.

I checked multi-table join syntax examples and looks like two different type of writing -as shown below- is acceptable.

SELECT aaa.x, bbb.y, ccc.z
FROM   aaa, bbb, ccc

SELECT aaa.x, bbb.y, ccc.z
FROM   aaa, bbb
JOIN   ccc

I wonder about what should i use in general multi-table joins, should i seperate tables with JOIN keyword or use all table names in FROM clause and why i should use first or second join syntax, is it just personal or better than another?

asked Dec 13 '16 at 14:15

ekrandondu

2

Use the second format - http://stackoverflow.com/questions/1599050/ansi-vs-non-ansi-sql-join-syntax – WillardSolutions Dec 13 '16 at 14:18
You should use JOIN for all tables after the first. The first syntax you have shown is extremely old and not best practice any more. – Rich Benner Dec 13 '16 at 14:18

SQL Multi-Table View Joins

0 Answers0