Thanks both Robert and Rich. I tried %ALL already and mapping, but it did not work...

I am missing something, obviously.

Here's what I have done:

- Created %ALL namespace

- Created a table OriginalNamespace.TableName

- Mapped the table in the Global Mappings for %ALL I used the Portal's System > SQL to create the table and to insert/select data from it.

As mentioned, not visible unless in the original namespace.

It is giving a result for either top n or without it, but only when "group by" is not there.

As soon as I add that line it spits out the error.