Thanks, that worked like a champ. I had a solution using 2 queries, but that
wasn't really elegant. This should be much better. Thanks!
Cedric
> Subject: JOIN help
> From: Jochem van Dieten <[EMAIL PROTECTED]>
> Date: Sun, 16 Nov 2003 13:53:17 +0100
> Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=28709&forumid=4#144210
>
> Pascal Peters wrote:
> > SELECT Q.QueueID, XUQ.AccessID, Q.QueueName
> > FROM Queues Q
> > JOIN SecurityXrefUserQueues XUQ
> > ON XUQ.QueueID = Q.QueueID
> > WHERE XUQ.UserID = <cfqueryparam cfsqltype="CF_SQL_NUMERIC"
value="#url.uid#">
> > UNION
> > SELECT Q.QueueID, NULL AS AccessID, Q.QueueName
> > FROM Queues Q
> > WHERE Q.QueueID NOT IN (
> > SELECT XUQ.QueueID
> > FROM SecurityXrefUserQueues XUQ
> > WHERE XUQ.UserID = <cfqueryparam cfsqltype="CF_SQL_NUMERIC"
value="#url.uid#">
> > )
>
> How about:
> SELECT
> q.ID,
> uq.AccessID,
> <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#url.uid#"> AS
> userID
> FROM
> queues q LEFT OUTER JOIN (
> SELECT uq.userID, uq.AccessID, uq.queueID
> FROM userqueues uq
> WHERE userID = <cfqueryparam cfsqltype="CF_SQL_INTEGER"
> value="#url.uid#">
> ) uq ON q.ID = uq.queueID;
>
> Jochem
>
> --
> Who needs virtual reality
> if you can just dream?
> - Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
