MySQL Forums
Forum List  »  Quality Assurance

table names in clause FROM of a subquery
Posted by: ugo moscato
Date: July 30, 2014 12:57AM

I report that if you use column names of a table A in clause select and where of a SUBQUERY you can omit A in clause FROM of the subquery if A appears in from of the main query. This doesn't work if you use clause GROUP BY on columns of A.Is this standard for SQL? How SQL manages this situation from an operational point of view?

Options: ReplyQuote

Written By
table names in clause FROM of a subquery
July 30, 2014 12:57AM

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.