🚀 go-pugleaf

"The DeerBear" <rainaple@tin.it> wrote in message
news:3e125625$1@newsgroups.borland.com...
>
> Using IBExpert PE, precompiling has problems with the following query:
>
> select accounts.user_id,accounts.title,
> accounts.first_name,accounts.last_name,accounts.user_id,roles.user_role
from
> ACCOUNTS acc
>       INNER JOIN ROLES R On R.user_id = Acc.user_id
>       where R.USER_ID = ( Select USER_ID From Accounts ( Where
> ACCOUNTS.USER_ID Not in ( REQ_USR_ID ) ) )
>       group by R.user_role

The set of fields specified for Group By must be the same as the set of
non-aggregate fields in the Select. This is ANSI standard. In this case you
have no aggregates (SUM, COUNT, etc) so all selected fields must also be in
the group by.

I have no idea what you are trying to do with "Not in ( REQ_USR_ID )", but I
don't believe you need the subselect either way, you should be able to
simply say " where R.USER_ID not in ...".

Explain what you are trying to get.

--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
"Democracy, without that guarantee of liberty, is merely a method of
selecting tyrants." - Alan Nitikman