>VFP has great documentation for its "SQL SELECT" command.
>However, if I am sending an SQL SELECT command to an Access97 database the syntax is different.
>Where can I find documentation on the "SQL SELECT" command when VFP is communicating directly with the ".mdb" file via SQL Pass through?
>
>Right now I am experimenting and building remote views and seeing what they produce in order to figure out what the syntax should be....
>kind of reverse engineering the remote view....
>
>I have sifted through some Access97 docs and cannot find anything...
>
>Any help is greatly appreciated...

In Access 97 help you can find this under Contents -> Microsoft Jet SQL Reference.