Hi All:

I am trying to get the following statement to work but I can't get IB to
let me use the 'union' operator in an 'insert'. Is there a trick?

insert into JUNK(ACCOUNTID,RESPONSE)
SELECT ACCOUNTID,'UNK' FROM CONTACTS WHERE ACCOUNTID=330
UNION
SELECT ACCOUNTID,'FIK' FROM CONTACTS WHERE ACCOUNTID=335

- Steve

--
Steven Peterson, President
Frontier Productions, Inc.
310 Wesley Drive
Chapel Hill, NC 27516
http://www.frontierproductions.net
Tel: 919-942-1386
Fax: 919-933-2677