Join 2 tables from different databases using database connector

0
Can I  Join 2 tables from different databases using the database connector module?
asked
1 answers
1

Hi Mohamed,

Short answer: no 😅

Long answer: using the database connector, you can execute a query to one specific database, resulting into objects in Mendix. If you query two databases, you will have two sets of objects, which cannot be joined by the database. You could of course associate them based on own logic, but you will need to write that logic separately and execute it after the database connector has executed both queries.

Good luck!

answered