Tricky SQL query

Tricky SQL query

El Forum
Guest

08-26-2008, 04:27 AM

[eluser]Dan Murfitt[/eluser]
Hi

Thanks for the swift reply Smile

This still produces duplicate results, as it's showing every conversation for every post - this is why I need the GROUP BY clause, so that it only returns one result for every conversationid. The problem is that the ORDER BY is performed after the GROUP BY clause. So, even though the ORDER BY is working (as the final result is ordered by the created field) the one post returned from the GROUP BY clause is incorrect. I hope this makes sense Confused

Any more ideas?

Messages In This Thread

Tricky SQL query - by El Forum - 08-26-2008, 03:38 AM

Tricky SQL query - by El Forum - 08-26-2008, 04:18 AM

Tricky SQL query - by El Forum - 08-26-2008, 04:27 AM

Tricky SQL query - by El Forum - 08-26-2008, 05:08 AM

Tricky SQL query - by El Forum - 08-26-2008, 05:31 AM

Tricky SQL query - by El Forum - 08-26-2008, 07:44 AM

Tricky SQL query - by El Forum - 08-26-2008, 07:48 AM

Tricky SQL query - by El Forum - 08-26-2008, 08:06 AM

Tricky SQL query - by El Forum - 08-26-2008, 08:32 AM

Tricky SQL query - by El Forum - 08-26-2008, 08:49 AM

Tricky SQL query - by El Forum - 08-26-2008, 08:54 AM

Tricky SQL query - by El Forum - 08-26-2008, 09:09 AM

Tricky SQL query - by El Forum - 08-26-2008, 09:22 AM

Tricky SQL query - by El Forum - 08-26-2008, 09:35 AM

Tricky SQL query - by El Forum - 08-26-2008, 10:05 AM

Tricky SQL query - by El Forum - 08-27-2008, 02:03 AM

Tricky SQL query - by El Forum - 08-27-2008, 08:25 AM

Tricky SQL query - by El Forum - 08-27-2008, 08:28 AM

Tricky SQL query - by El Forum - 08-27-2008, 08:34 AM