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"
403
December 19, 2021 09:23PM
273
December 20, 2021 10:57AM


Sorry, only registered users may post in this forum.

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.