Re: Difference between two SQL queries
Using comma join syntax you are able to leave off a join condition in the where clause. you will then have a cross join effect where every row from one table is returned for every row in the other table.
you can't leave off a join condition when you specifically use the INNER JOIN clause.
As for your second question you know how multiplication and division are performed before addition and subtraction in math questions?
Same things happen with joins, so you will get a join condition out of order if you join two tables with comma join syntax and mix in an INNER or OUTER join with the comma syntax.
---------------
Guelphdad,
Moderator
forums.mysql.com
Subject
Written By
Posted
Re: Difference between two SQL queries
July 18, 2011 05:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.