>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

Good question. I assumed that the example was simplified and that some other transformation which required an intermediate step. But, as it stands, it looks like you've got a point.

Jay