<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>18 Jun 2018 18:12:23 Z</lastBuildDate><pubDate>18 Jun 2018 18:12:23 Z</pubDate><description>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)&#13;
&#13;
Also tried by code, specifying in query databasename.dbo.table1... and so on. Compile launch error in dot (.) between dbo and table2...&#13;
&#13;
select * from table1 inner join database2.dbo.table2 on ...&#13;
&#13;
No way&#13;
&#13;
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?</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65880-how-create-fully-functional-query-joining-tables-from/read.awp</link><title>How to create a fully functional query joining tables from more than one SQL Server databases</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster></channel></rss>
