Re: Curious Join issue causing an E_FAIL error (with odbc

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: s(dot)vanroye(at)easytowork(dot)nl
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Curious Join issue causing an E_FAIL error (with odbc
Date: 2006-11-13 04:48:22
Message-ID: 4557F916.1040306@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Stijn Vanroye wrote:
> Hi List,
>
> I have experienced a strange issue today: when executing a query with a
> 3-level join in it I got an E_FAIL error in my client software. I did
> manage to "fix" it but I still find it strange.
>
> Suppose you have the following situation:
>
> there are three tables A,B and C (quite dumb names I know)
>
> and the following query:
>
> select
> <some fields>,
> C.id
> from
> A
> left join B on (A.fkB_id=B.id)
> left join C on (b.fkC_id=C.id)
>
> The above query produces the error.

Could you show me the whole code ?

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Stijn Vanroye 2006-11-13 08:42:44 Re: Curious Join issue causing an E_FAIL error (with odbc
Previous Message Hiroshi Inoue 2006-11-12 23:44:05 Re: Serial columns and ADO