如何用子查询和Exists关键字查看哪一些员工在仓库中借过东西

Question

问：如何用子查询和Exists关键字查看哪一些员工在仓库中借过东西？

Answer 1

select * from employee a where exists (select 1 from storage b where a.员工编号=b.借物员工编号)