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
