Tricky SQL query

Tricky SQL query

El Forum
Guest

#10

08-26-2008, 08:49 AM

[eluser]ehicks727[/eluser]
Does this producing the result you expect? Or is it the same as the WHERE... GROUP BY

Code:
SELECT conversations.* FROM conversations

JOIN conversations_posts ON conversations.conversationid = conversations_posts.conversationid

GROUP BY conversations_posts.conversationid

HAVING conversations.teamid = 1

ORDER BY conversations_posts.created DESC

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