Actually I have two tables as following:
t1(orderid,batchnumber,gtin,expdate,password);
t2(orderid,batchnumber,gtin,expdate);
t1 has 1000 records with only password and other fields has null values
t2 has 1000 diferent records
Now I,m looking for a way to update t1 null values with t2 values