UserID QueueID AccessID
2 1 0
I never get the NULL row. Any more ideas?
Cedric
>A left outer join?
>
> -----Oorspronkelijk bericht-----
> Van: Cedric Villat [mailto:[EMAIL PROTECTED]
> Verzonden: za 15/11/2003 2:52
> Aan: CF-Talk
> CC:
> Onderwerp: JOIN help
>
>
> Here is my query now, but all it returns are rows in which there are entries
> in the UserQueues table.
>
> SELECT Q.QueueID, AccessID, Q.QueueName
> FROM Queues Q
> RIGHT JOIN SecurityXrefUserQueues XUQ
> ON XUQ.QueueID = Q.QueueID
> WHERE XUQ.UserID = #url.uid#
>
> Anyone have any idea how I can get the above result that I need?
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
