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