MySQL Forums
Forum List  »  General

Join Syntax Confusion
Posted by: Shawn Taylor
Date: May 18, 2011 07:55AM

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?


Options: ReplyQuote

Written By
Join Syntax Confusion
May 18, 2011 07:55AM
May 22, 2011 09:30AM

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.