--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> >The query in MS Access is:
> >
> >SELECT ADDRESS.NAME, STATUS.STATUSNAME, COUNTRY.COUNTRYNAME
> >FROM (ADDRESS LEFT JOIN STATUS ON ADDRESS.STATUSID = STATUS.ID)

LEFT

> >JOIN COUNTRY ON ADDRESS.COUNTRYID = COUNTRY.ID;
>
> Two problems here: (1) bad syntax and (2) ambiguity
> Is this the actual query statement that gets sent through the ODBC

interface?'

>
> You need to get it to accept correct, standard, unambiguous SQL:
>
> SELECT
> ADDRESS.NAME,
> STATUS.STATUSNAME,
> COUNTRY.COUNTRYNAME
> FROM ADDRESS
> LEFT JOIN STATUS
> ON ADDRESS.STATUSID = status.STATUS.ID
> LEFT JOIN COUNTRY
> ON ADDRESS.COUNTRYID = country.COUNTRY.ID;
>
> This query is going to return (potentially) a lot of nulls - I'm not

sure

> whether you regarded that as a problem or not. If you don't want

the nulls

> then you don't want the outer joins...

Hello Helen,

what you sent me is a correct SQL statement but, from MS Access, I can
use it only in a SQL-pass-through query. A pass-through query will not
be modified by the JetEngine. My intention was, to create a 'normal'
(not a pass-through) query.
The problem is, that a pass-through query stores the connection string
including UID and PWD used to connect to the FB DB. If UID and/or PWD
changes, all pass-through queries have to be modified.
So you don't know any other way to make it work, do you?

Jurgen