Where Or Join

[Oswald Coote]

Hello

What is a logical relationship or difference between WHERE and JOIN statements in terms of performance and desired results:

select user.first_name, user.last_name, orders.order no from user inner join orders user.c_id=user.c_id

and

select user.first_name, user.last_name, orders.order no from user, orders where user.c_id=orders.c_id

[dWight]

In my opinion, there is no difference between both even in terms of performance and results, however, one of those method is considered as the best practice while the other might be considered as deprecated.

[pathakg258]

Using JOIN makes the code easier to read, since it's self-explanatory.

In speed, there's no difference (I have just tested it), and the execution plan is the same....


Using the JOIN syntax allows you to more easily comment out the join as its all included on one line. This can be useful if you are debugging a complex query

[pathakg258]

Using JOIN makes the code easier to read, since it's self-explanatory.

In speed, there's no difference (I have just tested it), and the execution plan is the same....


Using the JOIN syntax allows you to more easily comment out the join as its all included on one line. This can be useful if you are debugging a complex query


Thanks
Name Abhishek Pathak
CoreItDevelopers