Hello guys, It's been 7 days since I joined Retool. After doing some explorations, I want to ask a couple question regarding query and pulling data from different databases.
I've created Mysql and Postgresql resources. Can I make a query like
select * from Mysql.user M left join Postgresql.order P on M.id = P.user_id ?
So, what I want is joining or combine two data or table from two different db system in a single query.
Or can I just make 2 different code in web app building one from Mysql query and one from Postgresql query? like in a table visual I want 3 columns from Mysql query and 2 columns comes from Postgresql query, can I do that?
I'm sorry if I'm asking an obvious question or if my english is not good. Feel free to add some pointer to my problem or give me some tips or some suggestions. Thank you guys!