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


Subject
Views
Written By
Posted
table names in clause FROM of a subquery
2010
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.