3 Replies Latest reply: Jul 15, 2013 10:30 PM by Michael Steedle RSS

    Where PersonSkill exists in RequiredSkill

    David Koschei

      Hi,

       

      Say I have 2 tables, Person and Company.

       

      Person has PersonSkill, Company has RequiredSkill.

       

      I want a list of PersonNames and CompanyNames where PersonSkill exists in RequiredSkill

       

      How can I do this?  Can it be done in a straight table, or only in the script?

       

      Thank you