Re: [Maria-developers] [Maria-discuss] Query ambiguity

2018-05-17 Thread Karthick Subramanian
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

Re: [Maria-developers] [Maria-discuss] Query ambiguity

2018-05-17 Thread 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