Hm, new one. Oracle 6:

SQL> select * from a where (x,z) in (select y, l from b);

         X          Z
---------- ----------
         1          2

SQL> select * from a where (x,z) = ANY (select y, l from b);

         X          Z
---------- ----------
         1          2

SQL> select * from a where (x,z) >= ANY (select y, l from b);
select * from a where (x,z) >= ANY (select y, l from b)
                            *
ERROR at line 1:
ORA-00920: invalid relational operator

: only '=' and '<>' are allowed if there are more than one 
expression on the left side of clause with subselect...

Is this in standard or Oracle' preference ?

Vadim
P.S. Maybe I should ask in DB newsgroups ?..

Mon, 16 Feb 1998 21:09:37 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Subselects open issue Nr. NEW