There are two tables named emp and ct1 Requirement is to get max(hiredate) from emp and update it to ct1 table.
used : Update ct1 set session_date=(select max(hiredate)from emp) where table_name='src1';
emp
name hiredate
A 12-12-2004
B 14-08-2000
ct1 table
table_name session_date
SRC1 null
SRC2 null