Insert Into with minus subquery 00947. 00000 - "not enough values"
DanCodiFeb 1 2012 — edited Feb 1 2012I am trying to write an insert statement using MINUS but can't seem to get the syntax right or will this even work?
I am using minus because it is the most accurate with the data in the table.
INSERT INTO PROVIDER_TESTS (PROVIDER_TESTS_ID, PROVIDER_ID,ALL_CODE_ID,ORDINAL,GENERIC_DESCRIPTION,FASTING_HOURS,URGENCY,ABN_INDICATOR,PROCEDURE_ID,COMPENDIUM_ID)
VALUES(SEQ_PROVIDER_TESTS_ID.NEXTVAL,2395350,
(SELECT ALL_CODE_ID,ORDINAL,GENERIC_DESCRIPTION,FASTING_HOURS,URGENCY,ABN_INDICATOR,PROCEDURE_ID,COMPENDIUM_ID
FROM PROVIDER_TESTS WHERE PROVIDER_ID =921
MINUS
SELECT ALL_CODE_ID,ORDINAL,GENERIC_DESCRIPTION,FASTING_HOURS,URGENCY,ABN_INDICATOR,PROCEDURE_ID,COMPENDIUM_ID
FROM PROVIDER_TESTS WHERE PROVIDER_ID = 2395350));
Thanks