<--- --------------------------------------------------------------------------------------- ---- 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 Orders LEFT OUTER JOIN Loger ON Loger.UserID = Orders.CartID SELECT DISTINCT (WebOrderID), cartID, Location, Delivery, Quantity, ItemNumber, Item, Price, Vendor, Attention, Price FROM realcart Where WebOrderID = '#theOrders.WebOrderID#'