Check if records exists in a table of a different database / LEFT JOIN with 2 databases

[mebeingken]

The ability to join results was added to wappler after I needed to do this, but I documented it here:

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…

You just use values from the first lookup inside the second lookup.