How? I've tried every variation that I can think of and it will never let me complete a nested query...<BR><BR>Example:<BR><BR>q = "(SELECT TOP 5 * FROM data WHERE ID > " & largeID & " ORDER BY ...

OpenSearch SQL uses OpenSearch nested query to query the nested field. In OpenSearch domain, the nested query can filter the nested field based the query logic which is correspond to the EXISTS in ...

A message appears at the top of the SQL Editor window to indicate which SQL is being used. If you need to use a different set of tables, you can create a new Query Manager or talk to your SAS Support ...