SQL & PL/SQL

Hi,

Can we write Insert with 'Where' clause? I'm looking for something similar to the below one (which is giving me an error)

insert into PS_AUDIT_OUT (AUDIT_ID, EMPLID, RECNAME, FIELDNAME, MATCHVAL, ERRORMSG)

Values ('1','10000139','NAMES','FIRST_NAME',';','')

Where AUDIT_ID IN

(  select AUDIT_ID from PS_AUDIT_FLD where AUDIT_ID ='1' and RECNAME ='NAMES'

AND FIELDNAME = 'FIRST_NAME' AND MATCHVAL = ';' );

Thanks

Durai