Greetings, Here is the scenario the customer has presented.
3 Tables involved. Table 1 - Scheduled training for a year Table 2 - Employee information Table 3 - Completed training If I am understanding my customer and I believe I am, this is what they want to do. They want to run a query against the 3 previous mentioned tables, and output a list of the scheduled training showing a green check for completed and a red x for not completed. In my thinking, there will be nothing to evaluate in table 3 if they have not completed the training, since there will only be an entry for completed training. So if it is possible, how would it be accomplished? Thanks in advance Leonard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
