How to import data from multiple tables in entitlemementImportJSON in db Connector ?

[manish97]

I have a requirement where i need to import Roles/entitlements into entitlements table of saviynt from a table1 in db1. Along with that i need to import some of the attributes in saviynt entitlement table but from a diff table2 from db1.

How i can import data from multiple tables into entitlementImportJSON in db connector?

[nimitdave]

You can use union clause with select clause from both tables and keep same columns aliasing