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).
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only