While configuring Pega Insights , when we need to fetch data from multiple tables, we generally configure associations and use it.

In the scenario, Any idea how to configure the below query in pega insights.

<-----

SELECT Customers.CustomerID, Customers.CustomerName, Orders.OrderID, OrderDetails.ProductID, Products.ProductName

FROM Customers

INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID

INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID

INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID;

----->

 So far, we have created an insight on Customers Data Object and created association from Customers to Orders.

However, we are not able to configure for the nested join in associations. 

Please let us know if there is any way to do it.