<--- --------------------------------------------------------------------------------------- ---- Blog Entry: ColdFusion Optimizing Case Study: Writing Orders To A CSV File Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:679.view Date Posted: May 4, 2007 at 8:46 AM ---- --------------------------------------------------------------------------------------- ---> SELECT * FROM ( SELECT * FROM Orders LEFT OUTER JOIN Loger ON Loger.UserID = Orders.CartID ) AS o INNER JOIN realcart rc ON rc.WebOrderID = o.WebOrderID