Reputation: 175
Is it possible to join two tables from different database systems such as SQL and Netezza using any query language.
Specifically is it possible to achieve a join in AQT.
Is it possible for a tool like AQT ( Advanced Querying Tool) to provide a platform which allows us to connect the tables from these different database systems
Upvotes: 0
Views: 50
Reputation: 21
You can try creating linked server in SQL. But doing so have an overhead on the SQL server from DBA point of view. You need extra privileges to create a linked server.
Upvotes: 1