<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Ask Ben: ColdFusion Optimization, A Case Study Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:267.view Date Posted: Sep 13, 2006 at 12:16 PM ---- --------------------------------------------------------------------------------------- ---> SELECT o.id, o.date_ordered, o.supplier_id FROM orders o WHERE o.is_open = 1 SELECT s.id, s.name, s.phone, s.location FROM suppliers s WHERE id IN ( #ValueList( qOrder.suplier_id )# ) SELECT name, phone, location FROM qSupplier WHERE id = '#trim( qOrder.supplier_id )#'