Well dunno then, I just created a table in Access 2000, and ran:
SELECT *
FROM my_table
WHERE date > (SELECT MIN(date)
FROM my_table);
and it worked fine.
When you say "That just screws up the query" what actually happens?
Bert
-----Original Message-----
From: Russell Jones [mailto:[EMAIL PROTECTED]]
Sent: 24 October 2000 18:26
To: Fusebox
Subject: Re: ... should be a simple query question ...
Thanks Bert, I've tried that though. That just screws up the query.
-R
==============
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#">
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>
==============
--
Russell Jones
Webmaster
ImproveNow.com
Phone: 207.236.0146
e-mail: [EMAIL PROTECTED]
> From: Bert Dawson <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 24 Oct 2000 18:13:23 +0100
> To: Fusebox <[EMAIL PROTECTED]>
> Subject: RE: ... should be a simple query question ...
>
> I don't really know access, but maybe you want to drop the '=' sign from
the
> condition:
> ie
> AND m.MessageDateCreated > ALL
> (
> SELECT Min(m.MessageDateCreated)
> etc
>
> Bert
>
------------------------------------------------------------------------------
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.
