I think the OP needs to try a lot of googling and stackoverflow etc first and break the heads first and then post it here if it's really required. IMHO, if people start asking the SQL problems (mainly most of the sql issues are knowledge gap related) here, then I think the quality of this forum will be compromised. 

On Thu, May 17, 2018, 6:36 AM Pantelis Theodosiou <ypercube@gmail.com> wrote:
What Rhys said, please post queries as text, not as images.

The issue is likely due to the way you structured your query. You have put a derived table in a random place (in the SELECT list).

Please try to read about CTEs. It will help you design those complex queries better and make them more readable and easy to edit: https://mariadb.com/kb/en/library/with/

Best regards

Pantelis Theodosiou

On Thu, May 17, 2018 at 11:23 AM, <Rhys.Campbell@swisscom.com> wrote:

You're not making a lot of sense here. Please explain the "ambiguity". That's a fairly complex query so you should include as text.

 

"Does not work" <- In the image. It helps if you include error message.

 

From: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=swisscom.com@lists.launchpad.net] On Behalf Of Dev C
Sent: 17 May 2018 06:41
To: maria-discuss@lists.launchpad.net; Maria Developers <maria-developers@lists.launchpad.net>
Subject: [Maria-discuss] Query ambiguity

 

Hello 

 

I have query ambiguity as attached. Please help me on how to solve that.

 


_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp