CODE EXAMPLE FOR SQL

nested query

select E.ename from employee E where E.eid IN (select S.eid from salary S where S.regno=103);