(syntax)



INSERT INTO FAO_PERSONNEL

(EMPNO,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,DOH)

VALUES

(SELECT EMPNO,FIRSTNAME,MI,LASTNAME,DOB,DOH FROM EMPINFO WHERE EMPNO = 577)



I've tried it with parenthesis around the Select st8ment, and without. I
know I've used this (or something VERY similar before), but can't figure out
why it's complaining that the token SELECT is unknown.



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]