The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
I have two databases in the same server. One is Oracle and the other is Teradata. I want to join tables together using both databases. Similiar to below. Is this possible? I get an error when trying to join the tables.
Select * from Database1.Sales m inner join Database2.Part c ON m.part_number = c.part_nbr;