I have requirement to Join tables - multiple SQL Server tables with joins to ONE Oracle table with LIKE condition in ODBC Plug-in. I tried giving Oracle DB name in query and getting Invalid object name error.
Query in ODBC SQLServer connection -
select Asset, Tag from asset
join SQLSERVER.Portfolio on SQLSERVER.tid = SQLSERVER.tid
join ORACLE.LOCATION on ORACLE.LOCATION.code LIKE SQLSERVER. code
I'm not insisting on using two separate sources -one for SQLServer and other Oracle.
Thanks in advance
Sarathi
Join Two Tables from different databases in one Source Query
Moderators: chulett, rschirm, roy