I am trying to make this work with both MS SQL Server and MS Access (I can use two queries if necessary). Currently I am working in Access for this application.
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
----- Original Message -----
From: Christian Watt
To: CF-Talk
Sent: Friday, August 13, 2004 5:02 PM
Subject: RE: SQL Query
You need to take your Where clause out and include it on the join. I
believe that since you are including the outer joined table in the
where, you are not going to return any records that don't match the
Where statement.
FROM #request.levelTable# l
RIGHT OUTER JOIN #request.levelPricingTable# p ON l.levelID = p.levelID
and (p.productID = #url.productID# OR p.productID IS NULL)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
