Tricky SQL query

Tricky SQL query

El Forum
Guest

#11

08-26-2008, 08:54 AM

[eluser]ehicks727[/eluser]
Something is telling me you need to do a sub-query. Because it sounds like you only want the conversation with the latest create date, right? So there could be more than one conversation per user, tied to a conversation post, but you only want the last one. I just don't know how to get that in a single SELECT query.

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