Is this a bug or a limitation of the SQL language

I tried to do this query in Oracle and DB2 and both failed. I know its not allowed but why not?

Assume the use of the classic oracle emp table

select * from emp
where salary between
(select salary from emp where ename = 'Larry')
and
(select salary from emp where ename = 'John')

Isnt this the best way of finding all people whose salaries lie between those of Larry and John (without knowing whose is larger)

sjha_at_prism.poly.edu Received on Sun Aug 23 1992 - 09:40:48 CEST