8 Replies Latest reply: Feb 12, 2013 8:49 AM by Manideep Hv RSS

    Join 3 tables

      Hi,

       

      I have three tables each with a key field (CustomerID) but within those tables there are 2 other fields (Title, Status) that are the same but have different values.  How does one combine them so that I do not get the $Syn 1.  I need to combine them for reporting purposes but when i do that i have 3 key fields.  If I run a left join, then I am unable to view the distinctions between the fields. 

       

      I believe there is a simple solution.

       

      Any help is greatly appreciated.

       

      Thank you,

       

      Nicholas