BTW; Thanks all of your awesome feedback, I solved the problem I was having.
here was the correct way to add a left join in access ... well, at least it
works :)
-Russ
==============
<cfquery name="request.getMessageTaxonomy" datasource="#request.userdsn#"
cachedwithin="#CreateTimeSpan(0,0,IIF(Flush,0,QueryCacheTime),0)#">
SELECT m.*,u.*, m.MessageID AS ItemID, m.MessageParent AS ParentItemID
FROM Messages m
LEFT JOIN Users u ON m.UserID = u.UserID
WHERE m.ThreadID = #attributes.ThreadID#
</cfquery>
==============
> From: Russell Jones <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Mon, 23 Oct 2000 22:38:03 -0400
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: ... should be a simple query question ...
>
> First off, I'm using Access 2000...
>
> I need this query to get all messages in a thread except the first message
> that started it. What I have clearly does not work. I seems like it should,
> but it doesn't.
>
> ==============
> <cfquery name="request.getMessageTaxonomy" datasource="#request.userdsn#"
> cachedwithin="#CreateTimeSpan(0,0,IIF(Flush,0,QueryCacheTime),0)#">
> SELECT m.*, m.MessageID AS ItemID, m.MessageParent AS ParentItemID
> FROM Messages m
> WHERE m.ThreadID = #attributes.ThreadID#
> AND m.MessageDateCreated >= ALL
> (
> SELECT Min(m.MessageDateCreated)
> FROM Messages m
> WHERE m.ThreadID = #attributes.ThreadID#
> )
> ORDER BY m.MessageDateCreated ASC
> </cfquery>
> ==============
>
> I know I could cut out the first record with CF when I output it, but I'd
> like to do it in the query because I know it can be done.
>
> Are there any giving experts out there to answer my cry for help?
>
> Thanks.
>
> -Russ
>
> ------------------------------------------------------------------------------
> ------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
> message with 'unsubscribe' in the body to [EMAIL PROTECTED]
>
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
