select CustCode,* from solist a where not exists
(select 1 from SOList(nolock) left join so(nolock) on solist.soid=so.SOID where a.ConfirmDate>solist.ConfirmDate )
转载于:https://www.cnblogs.com/wwwlzp/p/8974938.html
select CustCode,* from solist a where not exists
(select 1 from SOList(nolock) left join so(nolock) on solist.soid=so.SOID where a.ConfirmDate>solist.ConfirmDate )
转载于:https://www.cnblogs.com/wwwlzp/p/8974938.html