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 ...

1. The V2 engine lacks functionality to query nested object types in OpenSearch - The nested function is not present in the V2 engine and is one option for user to query nested object field types in ...

In some cases, performance issues can arise with SELECT statements. The issue is that number of rows tends to grow rapidly as more tables are joined, as result set is de-normalized and contains a lot ...

Hello all!<BR><BR>So I'm work on learning O-R sql, and I'm having trouble with creating a table that has more than one nested table. <BR><BR>My code and errors are as ...

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 ...