Re: IN [ODBC with multiple tables

"MGFoster" <me_at_privacy.com> wrote in message news:CsPWd.3292$cN6.1238_at_newsread1.news.pas.earthlink.net...
> Randy Harris wrote:
> > I have been using "IN" to query tables in Oracle from MS Access very
> > successfully.
> >
> > Select Field FROM MyTable IN [ODBC...etc
> >
> > Works great if there is only one table involved. Anyone know how I can
use
> > the same technique with multiple tables (and be certain that the join
occurs
> > at the server).
> >
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Microsoft recommends that instead of the IN <table> clause you link any
> tables you want to the Access db file. Then run queries against the
> linked tables.

Would you happen to know why Microsoft recommends that (other than joins), or where I can read more about that recommendation?. I'm using IN <table> in quite a few places, wondering what problems I've caused myself.

> You can also run SQL Pass Through (SPT) queries, then all the work will
> be done on the Oracle server & only the results passed back to Access.
>
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBQivDrYechKqOuFEgEQLU/QCdF9eXJrBbteh47GQhGuB0k9nrDyIAoNWm
> nsoYNJ/0ib2yo6xfCmKdxjVV
> =gsnp
> -----END PGP SIGNATURE-----
Received on Sun Mar 06 2005 - 21:33:35 CST