I have been taught in my MSSQL classes, this is how to join two tables
select * from FirstTable A JOIN SecondTable B on A.ID= B.ID
Now in my professional life, I came across JOIN queries like this
select * from FirstTable A, SecondTable B where A.ID=B.ID
I know the second option was once norm but perhaps now abandoned.
I find that in complex queries where I join 6+ tables + have a number of sub queries , the second form is a lot easier to understand and is short and pretty.
- Which one should I use?
- Is there an advantage of one over the other?