| Subject | Re: [firebird-support] What is wrong with this sin tax? |
|---|---|
| Author | Magnus Titho |
| Post date | 2005-09-29T15:03:49Z |
Clay Shannon wrote:
(EMPNO,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,DOH)
SELECT EMPNO,FIRSTNAME,MI,LASTNAME,DOB,DOH FROM EMPINFO WHERE EMPNO = 577
should work.
--
Magnus
>(syntax)INSERT INTO FAO_PERSONNEL
>
>
>
>INSERT INTO FAO_PERSONNEL
>
>(EMPNO,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,DOH)
>
>VALUES
>
>(SELECT EMPNO,FIRSTNAME,MI,LASTNAME,DOB,DOH FROM EMPINFO WHERE EMPNO = 577)
>
>
>
(EMPNO,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,DOH)
SELECT EMPNO,FIRSTNAME,MI,LASTNAME,DOB,DOH FROM EMPINFO WHERE EMPNO = 577
should work.
--
Magnus