MySQL Forums
Forum List  »  Newbie

SELECT contains a subquery in the FROM clause
Posted by: Audio Zone
Date: August 23, 2017 05:12PM

Any suggestions on how to break the query to work in MySQL 5.4? When saving the view the error appears: "View's SELECT contains a subquery in the FROM clause"

select t3.*
from
(select t1.*, (select count(*)
from acadejuc_diarioprint t2
where t1.acadejuc_servidores_Nm<=t2.acadejuc_servidores_Nm
and t1.acadejuc_diarioClasse_ID=t2.acadejuc_diarioClasse_ID) as rownum
from acadejuc_diarioprint t1) t3
order by acadejuc_diarioClasse_ID,acadejuc_servidores_Nm ASC;

Options: ReplyQuote


Subject
Written By
Posted
SELECT contains a subquery in the FROM clause
August 23, 2017 05:12PM


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.