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)
Subject
Views
Written By
Posted
Missing a "FROM"
753
December 19, 2021 09:23PM
506
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.