From: | Stuart Barbee <sfbarbee(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: SQL query problem |
Date: | 2003-10-10 03:51:24 |
Message-ID: | 20031010035124.36809.qmail@web41506.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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(at)lewczuk(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Bartlett | 2003-10-10 06:09:30 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |
Previous Message | Network Administrator | 2003-10-10 03:07:25 | Re: process hangs using perl? |
From | Date | Subject | |
---|---|---|---|
Next Message | Iain Sinclair | 2003-10-10 05:51:54 | smart(er) column aliases |
Previous Message | Karsten Hilbert | 2003-10-09 21:33:08 | Re: SQL query problem |