2. PHPRunner General questions
  3. Joining Cross-Database -MySQL to SQL Server
This topic is locked

Joining Cross-Database -MySQL to SQL Server

 		4/7/2017 7:23:48 PM
PHPRunner General questions
K
 klyle author

Any ideas on why I can't get an int 919 in MySQL to match up to an int 919 in SQL Server (a non-PK field)?
I guess I need to understand the "masterkey" ? which seems to be the PK value of the related record in the SQL Server table (479), but that record doesn't show, just Add New.
Thanks in advance for any constructive thoughts.
Sergey Kornilov admin 4/10/2017

It won't work if you like to join these two tables in SQL Query. It should work as master-details though.
K
 		klyle author 4/10/2017

Thanks. It is Master-Detail. Let me try again, verify, and upload to Demo Server if needed.
K
 		klyle author 4/10/2017

Building the upload to the Demo System now. Will post the details to Support. Thanks!