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]
