Re: LEFT JOIN WHERE GROUP BY

[irek kordirko]

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.