|
| Inicio → WINDEV 2024 → How to create a fully functional query joining tables from more than one SQL Server databases |
| How to create a fully functional query joining tables from more than one SQL Server databases |
| Iniciado por carlos, 18,jun. 2018 18:12 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 18,junio 2018 - 18:12 |
We've tried with two different connections: query appears to be ok and tables from both connections appears in analisys, but does not shows data (of course sql sentence is working in SSMS)
Also tried by code, specifying in query databasename.dbo.table1... and so on. Compile launch error in dot (.) between dbo and table2...
select * from table1 inner join database2.dbo.table2 on ...
No way
So, the question: how to have a query from two or more SQL databases and use it as Lync to a table or other controls? |
| |
| |
| | | |
|
| | | | |
| | |
|