MySQL Forums
Forum List  »  Optimizer & Parser

Re: LEFT JOIN WHERE GROUP BY
Posted by: irek kordirko
Date: April 03, 2012 05:40PM

Daniel Flöijer Wrote:
-------------------------------------------------------
> Thanks, but it still doesn't work when I add the

It's hard to say what is the problem.
I can't see your data.
I don't know your table structures.
No one can say looking only on your query if, for example, a create_date field
is a field from support table or from support_internalstatus.
Please post table structures (output of SHOW CREATE TABLE tablename),
also post some sample data in a form of "INSERT INTO table VALUES xxxxx",
that will help people on this forum to easy recreate your case
on their computers and provide help.

Options: ReplyQuote


Subject
Views
Written By
Posted
2425
April 02, 2012 02:51AM
992
April 02, 2012 12:04PM
1044
April 02, 2012 01:24PM
1084
April 02, 2012 04:29PM
1620
April 03, 2012 12:50AM
Re: LEFT JOIN WHERE GROUP BY
1050
April 03, 2012 05:40PM
1158
April 03, 2012 11:22PM
1018
April 04, 2012 05:12PM
823
April 04, 2012 11:10PM
1264
April 05, 2012 08:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.