Tuesday, December 16, 2008

Multi column check in sub query

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.

 

No comments:

Post a Comment