MySQL Forums :: General :: Join Syntax Confusion


Advanced Search

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?

Shawn

Options: ReplyQuote


Subject Written By Posted
Join Syntax Confusion Shawn Taylor 05/18/2011 07:55AM
Re: Join Syntax Confusion laptop alias 05/18/2011 08:14AM
Re: Join Syntax Confusion Shawn Taylor 05/18/2011 08:22AM
Re: Join Syntax Confusion laptop alias 05/18/2011 12:39PM
Re: Join Syntax Confusion Shawn Taylor 05/18/2011 12:52PM
Re: Join Syntax Confusion laptop alias 05/18/2011 01:09PM
Re: Join Syntax Confusion Shawn Taylor 05/19/2011 07:04AM
Re: Join Syntax Confusion Rick James 05/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.