I just had it backwards....
Mike
-----Original Message-----
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 8:10 AM
To: CF-Talk
Subject: RE: Selecting TOP "N"
Which way round are you putting it in?
This works:
SELECT DISTINCT TOP 10 fields
> -----Original Message-----
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 09, 2004 8:00 AM
> To: CF-Talk
> Subject: Selecting TOP "N"
>
>
> I can't seem to get SELECT TOP 10 to work when the query
> below has a DISTINCT clause in it... Can anyone shed some
> light into my confusion.
>
> SELECT
> DISTINCT(T.opportunityId),
> O.title,
> O.createDate,
> U.firstName,
> U.lastName,
> U.emailAddress
> FROM
> tbl_ta T
> INNER JOIN tbl_opportunity O ON (T.opportunityId =
> O.opportunityId)
> INNER JOIN tbl_user U ON (O.createUserId = U.userId)
> WHERE
> EXISTS
> (
> SELECT
> O.title
> FROM
> tbl_opportunity O
> )
> ORDER BY
> O.title ASC
>
> Thanks!
>
> Mike
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
