-----Original Message-----
From: DI Hasenöhrl
> Hi,
> I use MsAccess97 as frontend and Postgresql as backend and till now I
thought, that there
> is no difference between a pass-through-query and a query,that I send via
ODBCdirect
> connection to postgresql. But now I have the followig miracle.
> If I make a pass-through-query with LEFT JOINs, I get the correct rows,
but by developing
> the syntax via VBA and transferring this code by an ODBCdirect connection,
I get only the
> rows of a normal INNER JOIN.
Please try the newest dll at http://w2422.nsk.ne.jp/~inoue/ .
regards,
Hiroshi Inoue