Page 1 of 1

Can I join tables from different databases?

Posted: Sun Feb 08, 2026 1:25 pm
by gio.cot
Hi all
i would need to execute SQL statement (in RPGLE program) that join a IBM i Table with a MySql table that is stored in a external data base (windows server) ...
in your opinion is it possbile ??
Thanks in advance

Re: Can I join tables from different databases?

Posted: Tue Feb 10, 2026 10:03 am
by Scott Klement
I very much doubt that this is possible. Joining is done by the code inside the database engine... you'd need a database engine that understands both databases, and I don't think there is such a thing.