4 Replies Latest reply: Jun 25, 2012 5:51 PM by Jason Michaelides RSS

    Compare tables and add Flag

    Hardik Gandhi

      Hi,

       

      I need to compare two tables based on MEMBERID. If the MEMBERID match I have to add a flag Yes and if the MEMBERID don't match up its No.

       

      The base table is MailingList table and I have to compare it with the Member table.

       

      MailingList:

      MEMBERID

      ADDRESS

      STATE

      COUNTY

      EMAIL

       

      I have to add flag in the MailingList table. (Flag: Yes/No)

       

      Member:

      MEMBERID

      ADDRESS

      STATE

      COUNTY

      EMAIL

       

      Thanks,

      H