X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id C8908D1B509
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 10 Oct 2003 03:52:14 +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 13459-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 10 Oct 2003 00:51:26 -0300 (ADT)
Received: from web41506.mail.yahoo.com (web41506.mail.yahoo.com
 [66.218.93.89])
	by svr1.postgresql.org (Postfix) with SMTP id 50107D1B520
	for <pgsql-sql@postgresql.org>; Fri, 10 Oct 2003 00:51:25 -0300 (ADT)
Message-ID: <20031010035124.36809.qmail@web41506.mail.yahoo.com>
Received: from [129.33.49.251] by web41506.mail.yahoo.com via HTTP;
	Thu, 09 Oct 2003 20:51:24 PDT
Date: Thu, 9 Oct 2003 20:51:24 -0700 (PDT)
From: Stuart Barbee <sfbarbee@yahoo.com>
Subject: Re: SQL query problem
To: pgsql-sql@postgresql.org
In-Reply-To: <003401c38e9e$f1e74b70$f16b4cd5@marek>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/108
X-Sequence-Number: 15508

Marek,

Not sure but, try switching the lines

  db_data.mda_mod_con _CON, 
  db_data.set_mda_fue _FUE 

with 

  db_data.set_mda_fue _FUE, 
  db_data.mda_mod_con _CON 

so there query is:

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_mak_eng _ENG,
  db_data.set_mda_fue _FUE,
  db_data.mda_mod_con _CON
  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



--- Marek Lewczuk <newsy@lewczuk.com> wrote:
> 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:



__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com