6 Replies Latest reply: Jan 11, 2013 10:14 AM by Darren Johnson RSS

    Outer Join Help

    Darren Johnson
      Hello,
      I have two tables as below...
      VariantOrders:
      DateItemVariant_KeyOrders
      1 Jan11123
      1 Jan12324
      1 Jan13354
      2 Jan14634
      2 Jan15344
      VariantViews:
      DateItemVariant_KeyViews
      1 Jan11332
      1 Jan12112
      1 Jan16467
      2 Jan17578
      3 Jan17654
      I want to end up with a link table like:
      DateItem Variant_KeyOrdersViews
      1 Jan11123332
      1 Jan12324112
      1 Jan13354-
      1 Jan16-467
      2 Jan14634-
      2 Jan15344-
      2 Jan17-578
      3 Jan17-654
      The 'Variant_Key' is basically a concatination of 'Item' and 'Date' and is unique.
      I need to do an 'outer' join, but need to keep the 'Date' and 'Item' fields in the link table as they are used to link other tables.
      Can anyone advise?
      Many Thanks
      Darren