Tricky SQL query

Tricky SQL query

El Forum
Guest

08-26-2008, 08:32 AM

[eluser]mdowns[/eluser]
Why not add a column to the conversations table called LastPost which would be a datetime? Each time you insert a row into the conversations_posts table, update the LastPost date in the conversation table (either manually or by creating a trigger). That would make the query a lot easier.

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