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??
Hi
You need to do an inner join on tMap based on num column, please refers to this KB
article, for table B, remove all the letters and [] before join.
Regards
Shong
