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

    JOINS - How do I JOIN these tables

    Byron Van Wyk

      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

       

      Table1:

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

       

      Table2:
      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.

       

      Thanks,
      Byron