Update from a table. - Mailing list pgsql-novice

Hi,

I want to update one table from another table based on a criteria.  For
instance:

            table1                           table2
employee | salary | netSalary         employee | deductions

I want to update table1.netSalary to be table1.salary - table2.deductions where
   table1.employee = table2.employee.

I don't see any way to do something like this with the syntax.  What am I
missing, or what can be recommended?


-- Andrew Bell
acbell@iastate.edu