I need to duplicate rows in a table with unique index using sql.
I try to run this statement:
insert into
MINUY_MADRICHIM(TAARICH_MINUY_ME,TAARICH_MINUY_AD,SUG_TEUDA,
ZEHUT_MORE,TAARICH_HAFAKAT_MINUY,MAKOR_TAKZIV,SAL_HADRACHA,MINHAL,
YECHIDA,TCHUM,ZEHUT_MEFAKEACH,STATUS_MINUY_HADRACHA,YOM_HADRACHA,
SEVEV_HADRACHA,MOSAD_HADRACHA,SHAOT_HADRACHA,BASIS_MISRA,
PITZUL_MISRA,TAA_IDKUN,SUG_MAKOR_MEDA,MAKOR_MEDA,MACHOZ_MEADKEN,
MACHOZ_MAAVIR,TAARICH_HAAVARA_ME_MACHOZ,TAHALICH_MAAVIR)
values ('1-sep-2004', '31-aug-2005',(select SUG_TEUDA,ZEHUT_MORE,
TAARICH_HAFAKAT_MINUY,MAKOR_TAKZIV,SAL_HADRACHA,MINHAL,YECHIDA,
TCHUM,ZEHUT_MEFAKEACH,STATUS_MINUY_HADRACHA,YOM_HADRACHA,
SEVEV_HADRACHA,MOSAD_HADRACHA,SHAOT_HADRACHA,BASIS_MISRA,
PITZUL_MISRA,TAA_IDKUN,SUG_MAKOR_MEDA ,MAKOR_MEDA,MACHOZ_MEADKEN,
MACHOZ_MAAVIR,TAARICH_HAAVARA_ME_MACHOZ,TAHALICH_MAAVIR from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'));
And I get this error message:
%SQL-F-SUBTOOVAL, Column select expression specifies too many columns.
Did any one have an idea how can I fix this problem?
Thanks
|
