I want to update one table from another table based on a criteria. For
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
pgsql-novice by date
|Next:||From: König, Frank||Date: 2001-11-21 14:15:22|
|Subject: upper and lower doesn't work with german umlaut?|
|Previous:||From: Juan Jose Natera Abreu||Date: 2001-11-20 20:02:58|
|Subject: Re: Info about DBI::Sybase.|