Sql查询过滤重复的数据

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 )

posted on 2018-04-30 22:08  wwwlzp  阅读(217)  评论(0编辑  收藏  举报

导航