ainpoissee wrote:

>
> When executing query
>
> SELECT r0.UID FROM TAB_A r0 WHERE ((SELECT COUNT(1) FROM TAB_B WHERE
> r0.UID = AID) BETWEEN 1 AND 10)
>
> I get following error:
>
> Unsupported field type specified in BETWEEN predicate.

Subqueries are not allowed for BETWEEN. This is a known limitation.


Dmitry