一招半式走江湖

原创 Oracle 使用Exists 遇到的问题

系统订单查询功能 一段权限管控代码大致代码为: select * from custorder_header a inner join custorder_detail b on a.order_no = b.order_no where 1 = 1   and a.order_no = 'A123456' and (exists (select 1 from view_statue where a.sendstation = name and typecode = 'A' and user_id = '5