> 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]
