← Back to team overview

maria-discuss team mailing list archive

Re: Query ambiguity

 

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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Dev C
> *Sent:* 17 May 2018 06:41
> *To:* maria-discuss@xxxxxxxxxxxxxxxxxxx; Maria Developers <
> maria-developers@xxxxxxxxxxxxxxxxxxx>
> *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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>

PNG image


Follow ups

References