syntax - SQL left join vs multiple tables on FROM line? - Stack Overflow

Most SQL dialects accept both the following queries: SELECT a.foo, b.foo FROM a, b WHERE a.x = b.x SELECT a.foo, b.foo FROM a LEFT JOIN b ON a.x = b.x Now obviously when you need an outer join,... ... The second is preferred because it is far less likely

stackoverflow.com