Re: Access '97 {oj ...} Left Join

"Henshall, Stuart - WCP" wrote:
>
> Oh, that explains it :)
> As a quick query why does the ODBC driver report them as available? As this
> information is normally used by programs to determine if outer joins can be
> used then surely they should be reported as not working, IMHO (I'm guessing
> that humans read the docs to find a db's features). If this where the case
> then IIRC Access '97 would use its own method of performing the join (which
> is inefficient, but works).

It seems you are right.
I would change the driver report after the release of
7.1. Or hopefully I may be able to implement the {oj
functionality.

regards,
Hiroshi Inoue