This question already has an answer here:
- SQL JOIN Syntax in MS SQL 3 answers
First time caller here.
I have a question regarding best practices when joining tables. For example, both of the following queries return the same results:
SELECT i.id, p.first_name, p.last_name FROM individuals i, profiles p WHERE i.id = p.individual_id; SELECT i.id, p.first_name, p.last_name FROM individuals i INNER JOIN profiles p ON i.id = p.individual_id;
What are the pros / cons of these two approaches? Please let me know what you think. I'm interested in performance differences, but also in readability of the query, portability from one RDMS to another, etc.