Re: simple sql

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 25 Jul 2003 04:07:27 -0700
Message-ID: <1de5ebe7.0307250307.47b98b29@posting.google.com>

"SPIDERMAN" <consultant2b_at_hotmail.com> wrote in message news:<_YUTa.71483$R92.17537_at_news2.central.cox.net>...
> Could someone help me with writing a query that would accomplish the
> following. Thank you.
>
>
> PAY_TABLE: EMP_ID, DEPT_ID, COMMISSION
>
>
>
>
>
>
>
> Inserting into PAY_TABLE a new employee 10 who works for department 20 and
> earns a
>
> commission that is equal to the commission earned by employee 3

INSERT INTO PAY_TABLE ( EMP_ID, DEPT_ID, COMMISSION ) SELECT 10, 20 b.COMMISSION FROM PAY_TABLE b WHERE b.EMP_ID = 3;

Greetings, and don't ever forget Gwen Stacy. Received on Fri Jul 25 2003 - 06:07:27 CDT