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