Re: SQL question (using result of nested statement in arithmetic operation)

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 25 Apr 2003 11:16:18 -0700
Message-ID: <c0d87ec0.0304251016.164778c1@posting.google.com>

UPDATE Sequences

   SET seq_nbr = (SELECT MAX(seq_nbr)

                    FROM sequences) + 1

 WHERE seq_id = :id;

Without any DDL, I can only guess. It looks like you need a scalar subquery expression, but I have no idea what seq_nbr and seq_id mean since we have no DDL or specs for the table. Received on Fri Apr 25 2003 - 13:16:18 CDT