Join Syntax Confusion
I have the following join in a query I inherited
INNER JOIN (`db`.`tableA` `tableA` INNER JOIN `db`.`tableB` `tableB` ON `tableA`.`columnA`=`tableB`.`columnA`)
ON `tableC`.`columnF`=`tableB`.`columnF`
The part that has me confused is the parenthesis. My understanding is that these will change the precedence (Order of Operations) of the join order.
Such that Table A will be joined to Table B and that result set will be joined to Table C.
Is that correct?
Shawn
Subject
Written By
Posted
Join Syntax Confusion
May 18, 2011 07: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.