I will try to make this as simple as possible. Any help would be greatly appreciated. I have 3 tables like below. tblEmployees ----------------------------------------- EID | Name | 1, John 2, Bob 3, Steve 4, Brian 5, Joel 6, Lance -----------------------------------------
tblTraining ----------------------------------------- EID | JOB | 3, 1 4, 1 5, 3 3, 3 4, 2 ----------------------------------------- tblJobFunctions ----------------------------------------- JID | Job_Name | 1, Picking 2, Packing 3, Shipping ----------------------------------------- I was looking to produce results like this. Basically it will list ALL employees, and provide me with a scorecard type of training conducted. IS THIS POSSIBLE? NAME, PICKING, PACKING, SHIPPING John,No, No, No Bob,No, No, No Steve,Yes, No, Yes Brian,Yes, Yes, No Joel,No, No, Yes Lance,No, No, No ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3084 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
