<--- --------------------------------------------------------------------------------------- ---- 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, ( '' ) AS supplier_name, ( '' ) AS supplier_phone, ( '' ) AS supplier_location 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 )# )