Hi Hector !

Thanks, now I know that if the joining view is in SQLserver database I can do it. I tried with the view that was in VFP database so I have no propper results.
Greetings


>>The question is:
>>should I in SQL create one database that merges all my tables or am I something missing.
>
>In VFP you can use database!table in your SQL statement to work with several databases. In SQL server you can do the same, the syntax is: database.table
>
>select * from payroll!employee where x=y &&
>select * from payroll.employee where x=y &&
>
>The only restriction that I know is that all your databases must reside in the same SQL Server (because connections point to one server at a time as you said).