NRQL does not have an equivalent SQL-like
JOIN function. Also, there is no equivalent for nested queries or subqueries.
JOIN with custom attributes
To gain more in-depth data, you can add custom attributes to some data types.
For example, you want to know which browser types are experiencing the highest web duration for a specific product purchase. You could add a custom attribute named
Product to your application's purchase transaction method. Then you could run this NRQL query:
SELECT max(duration), average(duration), max(backendDuration), average(backendDuration) FROM PageView WHERE Product = 'Hat' FACET userAgentName SINCE 7 days ago