X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7EAE6D1B4EF for ; Thu, 9 Oct 2003 18:53:45 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 95840-02 for ; Thu, 9 Oct 2003 15:52:57 -0300 (ADT) Received: from smtp.lewczuk.com (unknown [195.150.168.118]) by svr1.postgresql.org (Postfix) with SMTP id 45155D1B4F6 for ; Thu, 9 Oct 2003 15:52:52 -0300 (ADT) Received: (qmail 12320 invoked by uid 700); 9 Oct 2003 18:52:37 -0000 Received: from pl241.warszawa.cvx.ppp.tpnet.pl (HELO marek) (213.76.107.241) by 217.96.100.118 with SMTP; 9 Oct 2003 18:52:35 -0000 Reply-To: From: "Marek Lewczuk" To: "Lista dyskusyjna pgsql-sql" , "Lista dyskusyjna pgsql-general" Subject: SQL query problem Date: Thu, 9 Oct 2003 20:52:58 +0100 Organization: LEWCZUK.COM Message-ID: <003401c38e9e$f1e74b70$f16b4cd5@marek> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: * X-Archive-Number: 200310/441 X-Sequence-Number: 50514 Hello, I'm in the middle of the migration process from MySQL to PostgreSQL and I cannot understand why this query isn't working (in MySQL it's working fine). PG returns: ERROR: Relation "_con" does not exist This is my query: SELECT _CON.con_id, _MOD.mod_ty, _VER.version, _YEA.year, _CON.dri_id, _CON.man_cod, _ENG.eng_pow FROM db_data.mda_mod _MOD, db_data.mda_mod_con _CON, db_data.mda_mak_eng _ENG, db_data.set_mda_fue _FUE LEFT JOIN db_data.mda_mod_ver _VER ON _VER.ver_id = _CON.ver_id LEFT JOIN db_data.mda_mod_yea _YEA ON _YEA.yea_id = _CON.yea_id WHERE _MOD.mod_id = '283' AND _CON.mod_id = _MOD.mod_id AND _CON.psd <= NOW() AND _CON.ped > NOW() AND _ENG.eng_id = _CON.eng_id AND _ENG.eng_fue = _FUE.fue_id I will be appreciated for you help. ML