>Hi Kevin. Thanks for your reply.
>
>My 2 joins was just an example. In VFP, I quite frwquently would have more than 3 joins with lots of where conditions, and from experience have found that breaking it up into a no. of joins is
>1. Easier to follow
>2. Easir to Debug
>3. Usually more efficient
> as you are crating Subsets all the way, and then working from these subsets on the subsequent selects.
>I also dont want to limit apps to Sql server as most of our clients are currenlty using VFP, and would like the option, with whatever the solution is, to ensure that it works in VFP and SQL.
>
>Taking your comments on board, is it not possible to have multiple selects as a source into a SqlDatasource ?
>
>Regards,
>
>Gerard

Gerard,
most of the SQL Server queries could be run on VFP 9 w/o any changes (you only need to change the functions you use in them to match VFP syntax). VFP9 supports derived tables in both FROM and JOIN clauses.