2 Replies Latest reply: Sep 1, 2011 4:06 AM by Byron Van Wyk RSS

    JOINS - How do I JOIN these tables

      Hi All,


      I have 2 tables. The 2nd table I want to join to my 1st table whereever the common fields match. So to illustrate



      Field a, Field b, Field c, Field D, Field E, Field F


      Field D, Field E, Field F, NEWFIELD  G


      I want fields D, E and F to reference to where those same values appear in table 1 (So there are 3 common fields). Whenever they do it needs to then add NEWFIELD G to table 1.