update table1 set columnName = "nice" where columnName_id not in ( select columnName_id from table2);