too many values error message in oracle

Question

I want to select some records using two tables avion and vol, but when I run my statement I get this error :

ORA-00913: too many values

This is my statement :

select distinct avion.avnum, avion.avnom from avion, vol
where avion.avnum  = vol.avnum 
AND vol.plnum in (
  select pilote.plnum, pilote.salaire from pilote
  where salaire > (
    select salaire from pilote
    where plnom ='Tsukishima'
  )
)
AND avion.avnom <> 'Boeing 777';

How can I solve this problem ?

Answer 1

Try this:

select distinct avion.avnum, avion.avnom from avion, vol
where avion.avnum  = vol.avnum 
AND vol.plnum in (
  select pilote.plnum from pilote
  where salaire > (
    select salaire from pilote
    where plnom ='Tsukishima'
  )
)
AND avion.avnom <> 'Boeing 777';