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

I'm starting another project and I'm currently designing our schema. I've got a couple many-to-many joins. I was wondering if a nested table is a better solution than simply creating an intersection ...

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