select
e.*
from
emp e
where
(e.eno, e.accno)
IN
(select eno, accno from bank order by eno)
Where the sub query will check both eno and accno.
  
e.*
from
emp e
where
(e.eno, e.accno)
IN
(select eno, accno from bank order by eno)
Where the sub query will check both eno and accno.
 
 
No comments:
Post a Comment