In your table structure, I see you have declared the primary key for each table, but I am unclear as to any foreign keys. Since the rest of the columns are varchars.
Can I assume that tbl_personnel.emp_id is a 'unique' id that represents each unique row? Can I assume the same for tbl_training_calendar.trng_code? If so, I would write Select p.first_name, p.last_name, p.emp_id, cal.trng_title, com.trng_status >From tbl_personnel p, tbl_training_calendar cal LEFT OUTER JOIN tbl_training_completed com ON com.emp_id = p.emp_id And com.trng_code = cal.trng_code Order by p.emp_id asc This is, of course, untested. -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -----Original Message----- From: Leonard Boche [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 7:50 AM To: CF-Talk Subject: Re: Is This Possible?? Hi Kris, First I would like to thank you for responding to my post, it is greatly appreciated. I will try to answer your questions in the order you presented them. Q1 - The ultimate goal of this project is to display a listing of the annual training calendar and show what training a given employee has and has not completed from that list. Q2 - Whether this can be accomplished with a single query or multiple queries, makes no difference to me. Q3 - Expected output would be something along the lines of this row 1: trng_code --- trng_title --- completed row 2: trng_code --- trng_title --- not completed row 3: trng_code --- trng_title --- completed and so forth running the through the table containing the annual training event information. Q4 - Not sure what you are looking for with this question. Q5 - Table structure >>> tbl_personnel --- record_id = key --- first_name (varchar) --- last_name (varchar) --- emp_id varchar >>> tbl_training_calendar --- record_id = key --- trng_code (varchar) --- trng_title (varchar) >>> tbl_training_completed --- record_id = key --- trng_code (varchar) --- emp_id (varchar) --- trng_status (varchar) With my current thinking process, the only time there would information entered into the tbl_training_completed table, would be when the individual actually completed said training. This I am having no problems with query and displaying. However, the issue I am having problems with is, determining what training of the scheduled training the individual has not done so I can include it in the same display / output in the layout described in Q3. The more I ponder on the scenario, the more I am becoming convinced it cannot be accomplished without pre-loading the trng_status field of the tbl_training_completed table with 'not completed' or NULL and query/evaluate against that. With there being 63 individuals and about 75 different training elements, pre-loading does not look pleasant. I am certainly open to suggestions on easier / more effective ways to accomplish this. I can do messengers as well as offer a virtual meeting session, if this would make reaching a solution easier. Thanks in advance, I hope I answered your questions. Leonard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
