Re: [Maria-developers] [Maria-discuss] 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,
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
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
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,
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
participants (2)
-
Karthick Subramanian
-
Pantelis Theodosiou