without knowing your type of rdbms used, exact data schema and how your 3 tables are linked to each other it is not possible to give you an exact solution. but in general, i would suspect that you will need to INNER JOIN your training and emplyoees tables and LEFT OUTER JOIN your employees table to completed trainings table, plus maybe use a CASE construct in your query, too...
Azadi Leonard Boche wrote: > 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:291064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
