>You could use a temporary table for that:
>CREATE TEMPORARY TABLE tmp (
> deptID INT NOT NULL,
> appSeq INT NOT NULL
>) AS
>SELECT deptID, max(appSeq) AS appSeq
>FROM approvers
>GROUP BY deptID;
>
>UPDATE approvers, tmp
>SET approvers.appName = 'Sting Ray'
>WHERE approvers.appName = 'Joe Bass'
I have some tables for placing orders. Depending on the department, an
order must be approved by 1, or more, specific approvers.
create table department (
deptID int not null,
deptName varchar(32),
...
)
create table approvers (
deptID int not null,
appS