Re: Curious Join issue causing an E_FAIL error (with odbc - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Curious Join issue causing an E_FAIL error (with odbc
Date
Msg-id 4557F916.1040306@tpf.co.jp
Whole thread Raw
In response to Curious Join issue causing an E_FAIL error (with odbc version 8.2.2.0)  (Stijn Vanroye <s.vanroye@easytowork.nl>)
Responses Re: Curious Join issue causing an E_FAIL error (with odbc
List 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

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Serial columns and ADO
Next
From: Stijn Vanroye
Date:
Subject: Re: Curious Join issue causing an E_FAIL error (with odbc