compare columns of two tables and update both the table
Hi , i want to compare one column of tables A with one column of table B. if both column values are not matching then i have to update both the tables with a new field value 0 or 1. example.. table A: id|num 1|213 2|415 table B: id|num 4|H 5|axdl so in the above two tables i have to join on num column.. here the second table contains the value of 1st table column but its in . so in this case its a match. so how to put this logic??