Aggregate Entitlement and Accounts from JDBC Source

For instance, giving that your accounts are in accounts table, your first entitlement type with key name ent_id (in the account schema in idn) is in table account_entitlements1 and your second entitlement type with key name ent2_id (in the account schema in idn) is in table account_entitlements2, the query to use in sailpoint will be :

select acc.*, links1.ent_id, links2.ent_id as ent2_id from accounts acc left outer join account_entitlements1 links1 on acc.acount_id = links1.acount_id left outer join account_entitlements2 links2 on acc.acount_id = links2.acount_id