3 Replies Latest reply: Nov 17, 2011 6:34 PM by John Witherspoon RSS

    Join Field2 in Table1 to Table2

    Joe Kirwan

      I have loaded Table1. It has fields ID and VAL. ID is unique.

       

      I have loaded Table2. It has ID and REF. There are multiple records for each ID.

       

      Now I want to add VAL from Table1 to Table2.

       

      I think it is LEFT JOIN, but could someone help me with the syntax?