I'm new here but have worked with DBs for a while and am trying to see if this is even possible. We have two databases (projects) - both are set up for sharing. If I create a single ODBC connection, can I connect between both databases?
For example, in SQL Server, I would do something like:
SELECT * FROM database.dbo.customers join database2.dbo.orders on customers.cust_id=orders.cust_id
Is that possible or do I need to create two separate ODBC connections and then join the two solutions together?
Thanks in advance.