MySQL Forums
Forum List  »  Newbie

Upgraded MySQL5.6 to MySQL5.7
Posted by: Paul Grimes
Date: May 01, 2021 06:24AM

Hi
Can anybody help me please?
I have this below and in MySQL5.6 it works fine, but in MySQL5.7 it does not work. After much google work, I found something along the lines that MySQL5.7 will not support an Alias with a where clause, but it was suggested to use a having. I just cant work out how to write the code to work that way? Any suggestions please?

IFNULL((select ROUND(sum(InvoiceSubtotal),2) from labour where labour.Job_No = job.Job_No), 0) AS Labsubtotal,

Thank you

Options: ReplyQuote


Subject
Written By
Posted
Upgraded MySQL5.6 to MySQL5.7
May 01, 2021 06:24AM


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.