This powerful query capability allows you to resolve business-critical incidents with your data in one simple query, enabling effective analysis and enrichment across datasets by joining related datasets using subquery JOINs. Subqueries are limited but can be overcome by using subquery JOINs, which allow for analysis and enrichment across datasets, making it easier to combine application performance monitoring (APM) event data and metrics, logs and infrastructure, synthetics and NrAuditEvent, or custom events. By utilizing subquery JOINs, you can join two result tables together, determine correlations between data from different sources, and gain insights about the health and performance of your application that may not be obvious or easy to correlate. The syntax of a subquery JOIN requires three components: dataset 1, dataset 2, and a primary key that links the two datasets together, with specific rules governing the structure of the query, including the use of parentheses, ON clause, and limitations such as a maximum result limit of 5,000 rows.