[AccessD] Selecting data from a table in another database

Jet only, according to John Viescas' Running Microsoft Access 97:

... Access implements four significant extensions to the [SQL] language:
    TRANSFORM...
    IN [remote db connection or column names in xtab]...
    DISTINCTROW...
    WITH OWNERACCESS OPTION ...

In any event, not in the SQL-92 standard.

Hen




>From: "John W. Colby" <jcolby at colbyconsulting.com>
>Reply-To: accessd at databaseadvisors.com
>To: <accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Selecting data from a table in another database
>Date: Sun, 16 Feb 2003 15:15:57 -0500
>
>Right, found it about 2 minutes after I sent the message.  So is this JTE
>sql specific?  It sure seems it would be.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>-----Original Message-----
>From: accessd-admin at databaseadvisors.com
>[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Henry Simpson
>Sent: Sunday, February 16, 2003 3:11 PM
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] Selecting data from a table in another database
>
>
>IN
>
>Hen
>
>
>
>
> >From: "John W. Colby" <jcolby at colbyconsulting.com>
> >Reply-To: accessd at databaseadvisors.com
> >To: "AccessD" <AccessD at databaseadvisors.com>
> >Subject: [AccessD] Selecting data from a table in another database
> >Date: Sun, 16 Feb 2003 13:41:07 -0500
> >
> >Someone (Gustav I believe) showed me how to select records from a table 
>out
> >in another database using a keyword in SQL.  Unfortunately I don't do it
> >often and can't lay my hands on it.  How is it done again?  Is this 
>keyword
> >specific to Jet or is it valid for all of SQL?
> >
> >John W. Colby
> >Colby Consulting
> >www.ColbyConsulting.com
> >
> >----------------------------------------------------
> >Is email taking over your day?  Manage your time with eMailBoss.
> >Try it free!  http://www.eMailBoss.com
> >
> >
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>
>_________________________________________________________________
>Help STOP SPAM with the new MSN 8 and get 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>
>----------------------------------------------------
>Is email taking over your day?  Manage your time with eMailBoss.
>Try it free!  http://www.eMailBoss.com
><< winmail.dat >>


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus