SQL query to update 1st table one column from another table
hello all im trying to update one column of first table from other table column,
I am using below update command but its not considering the second condition i.e. a.column2<>b.column2
UPDATE table1 a SET a.column1 = (SELECT b.column1 FROM table2 b WHERE
a.column1=b.column1 AND a.column2<>b.column2) ;
Thanks.