MySQL Forums
Forum List  »  Docs

Missing a "FROM"
Posted by: A SS
Date: December 19, 2021 09:23PM

Missing a "From" in this example :
https://dev.mysql.com/doc/refman/8.0/en/outer-join-simplification.html
Consider a query of this form, where R(T2) greatly narrows the number of matching rows from table T2:

SELECT * T1 LEFT JOIN T2 ON P1(T1,T2)
WHERE P(T1,T2) AND R(T2)

this sql should be : SELECT * FROM T1 LEFT JOIN T2 ON P1(T1,T2) WHERE P1(T1,T2) AND R(T2)

Options: ReplyQuote


Subject
Views
Written By
Posted
Missing a "FROM"
605
December 19, 2021 09:23PM
409
December 20, 2021 10: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.