X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4EDAED1B269 for ; Mon, 14 Jun 2004 14:06:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21599-03 for ; Mon, 14 Jun 2004 17:06:09 +0000 (GMT) Received: from hotmail.com (bay8-f81.bay8.hotmail.com [64.4.27.81]) by svr1.postgresql.org (Postfix) with ESMTP id 0179ED1B20E for ; Mon, 14 Jun 2004 14:06:06 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 14 Jun 2004 10:06:06 -0700 Received: from 69.65.137.210 by by8fd.bay8.hotmail.msn.com with HTTP; Mon, 14 Jun 2004 17:06:05 GMT X-Originating-IP: [69.65.137.210] X-Originating-Email: [el_vigia_ec@hotmail.com] X-Sender: el_vigia_ec@hotmail.com From: "Jaime Casanova" To: pgsql-sql@postgresql.org Subject: a query with = ALL Date: Mon, 14 Jun 2004 17:06:05 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 14 Jun 2004 17:06:06.0225 (UTC) FILETIME=[E16F2810:01C45231] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/110 X-Sequence-Number: 18055 Hi all, some more info a think can be useful to probe there is somting wrong. I pointed that the query select cur_paralelo from rec_m_cuadropagos WHERE ent_codigo = 1 AND sec_codigo = 1 AND ani_codigo = '2004-2005' AND cic_codigo = 1 AND esp_codigo = 0 AND cur_codigo = 1 intersect SELECT cur_paralelo FROM aca_t_curso WHERE ent_codigo = 1 AND sec_codigo = 1 AND ani_codigo = '2004-2005' AND cic_codigo = 1 AND esp_codigo = 0 AND cur_codigo = 1 brings 'A ', 'B ', 'C ' well when i cHange the real query SELECT CPA.rub_codigo, RUB.rub_descripcion, CPA.cpa_valor, CPA.cpa_fechavencimiento FROM rec_m_cuadropagos CPA, rec_m_rubro RUB WHERE RUB.ent_codigo = CPA.ent_codigo AND RUB.rub_codigo = CPA.rub_codigo AND CPA.ent_codigo = 1 AND CPA.sec_codigo = 1 AND CPA.ani_codigo = '2004-2005' AND CPA.cic_codigo = 1 AND CPA.esp_codigo = 0 AND CPA.cur_codigo = 1 AND CPA.cur_paralelo = 'A ' then it brings the result that it would but when i do the same with =ALL it doesn't work thanx in advance, Jaime Casanova _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus