How to Join fields from two separate databases?

[mebeingken]

Maybe this helps...

Two data sources, one output

Up to this point, my projects have had a single datasource, so querying with joins makes returning a single dataset straightforward. But what to do when you have two datasources where joins are not possible? Wappler makes it easy by using the repeat action and clever output options. [20%20AM] The two datasources: ‘hc’ is mysql, and ‘hcinternal’ is mssql on a remote server. query_job_orders gets the baseline information but I don’t output the query itself as I normally do. A repeat is use…