The CData Excel Add-In for PingOne supports standard SQL joins like the following examples.

Inner Join

An inner join selects only rows from both tables that match the join condition:

SELECT u.Id, u.Username, p.Id, p.Name FROM Administrators.Users u INNER JOIN Administrators.Populations p ON u.PopulationId = p.Id;

Left Join

A left join selects all rows in the FROM table and only matching rows in the JOIN table:

SELECT u.Id, u.Username, p.Id, p.Name FROM Administrators.Users u LEFT JOIN Administrators.Populations p ON u.PopulationId = p.Id;