Join two tables and update based upon equal and like condition : There are two tables.

**table 1**

    A   B      C
    =================   
    1  AAA   AA;BB
    2  BBB   CC;DD
    3  CCC   FF;G
    4  DDD   E

**table 2** (this table is expanded based upon columns C in above table which has ";" seperated values, these are expanded in terms of seperate rows)

    A    B    C   is_valid
    11   AAA  AA     0
    12   AAA  BB     0
    14   AAA  CC     0


Below table is formed by checking if the expansion is correct and is_valid flag is raised to 1. So checking needs to be done - Columns B should be exactly same in both the tables and part of column C present in table2 should be available with the same Column B value combination in table1.

**Expected table 2 after update query**

    A    B    C   is_valid
    11   AAA  AA     1
    12   AAA  BB     1
    14   AAA  CC     0
    17   DDD  E      1

Need to get help on formation of the update query for updating the is_valid column in table2.