>(Which join type is hidden behind the popup?) Sorry I left that covered up this time... Look here: http://www.redmondinc.com/sos/exe_plan.gif Is that sufficient?
>Can you give me the recordcount of the following queries: > SELECT DISTINCT proj_code, cust_job_num, cust_code, order_code > FROM ordr; -- 712 rows > SELECT DISTINCT tkt_code, tkt_date, truck_code, po, > truck_net_wgt, hler_code, order_code > FROM tick; -- 4724 rows > SELECT DISTINCT prod_descr, order_code > FROM ordl; -- 705 rows That's probably what you were asking for in your first message; sorry I misunderstood... thanks! -paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189079 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
