>Hi,
>
>I am trying to use several JOINs in a SELECT-SQL, but if I specify more than 9 joins, then VFP gives an error while executing the query. The error (#1805) is as follows:
>
>SQL:Too many subqueries.
>
>And to top that, I am not using any subqueries at all.
>
>Any idea?
>
>TIA,
>Hardik

You can always split you big SELECT to chain of smaller ones, and it will work faster. Start the chain with SELECT which will return smaller recordset.