I don't understand what you mean. It is not the provider that writes the SQL Statement, but Crystal? Or am I missing your point?

>Hi Everyone,
>
>I recently switched from ODBC to OLEDB data sources in all of my Crystal reports that access VFP8 databases. After the switch, I noticed that the SQL query returned from the OLEDB provider does not use ANSI 92 SQL syntax for joins. Rather, tables are joined in the where clause of the SQL SELECT... statement. ODBC returns ANSI 92 compliant join syntax, why doesn't OLEDB?
>
>TIA,
>Jeff