Leonard, There are a lot of ways to accomplish this. What are you trying to do? Are you trying to get the answer in a single query? What is your expected output? Do you have other schema info? What are the PK & FKs in each table? More info is needed to answer your question.
Cheers, Kris On 10/14/07, Leonard Boche <[EMAIL PROTECTED]> 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
