I have a SQL query for the output I need to have: <cfquery .......> select a.Dept, a.JobTitle, e.Shift, e.ExposureType, e.device, e.ExposureDate from exposure e, AssociatePersonal a where e.AssociateIDEx = a.AssociateID </cfquery>
The output I need to have is the sample output at http://www.mediafire.com/?9hzxddssiwy I uploaded an Excel spreadsheet (qryoutput.xls) for better explanations. Thx much ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
