Unless I have missed something (very possible today) isn't the SELECT unneeded? Should it be:

UPDATE Table2 SET Table2.commission = Table1.commission ;
WHERE Table1.emp_name = Table2.emp_name ;
AND Table1.rptdate = Table2.rptdate


Robert