Re: -360 Cannot modify table or view used in subquery

In my last message, I wrote: "The subquery means be a DB2 database", I did want mean that the sintax in the subquery that you wrote: "(SELECT NROHIS FROM GN_PACIENTE INNER JOIN TBPERPRIMARI ON TBPERPRIMARI.PRICDCIP || "00" = GN_PACIENTE.NROHIS WHERE pricdsituacion = 1 AND priidtippersona < 6 )" Seems be to db2 or sqlserver sintax ..... not in Informix SQL sintax. Best regards. Roberto F. "LUQUE Valdivia Omar" <luque001@marina.mil.pe> wrote in message news:<brng2h$m3p$1@terabinaries.xmission.com>... > Hello everybody, > > My query : > > UPDATE GN_PACIENTE > SET GRUPO = "G00" > WHERE NROHIS IN > (SELECT NROHIS FROM GN_PACIENTE INNER JOIN TBPERPRIMARI ON TBPERPRIMARI.PRICDCIP || "00" = GN_PACIENTE.NROHIS WHERE pricdsituacion = 1 AND priidtippersona < 6 ) > > I read the Informix error messages and i saw this paragraph, but I don't Understand that : "This action is not allowed because of the danger of getting into an endless loop." > Why is danger? > > I can do that in SQLServer and Access, why not in Informix? > > Thanks > > Omar. > > sending to informix-list