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