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