34,594
社区成员
发帖
与我相关
我的任务
分享
--只显示tbl_b的数据
select a.* from tbl_B a where createDate = (select max(createDate) from tbl_B where ProcessNo = a.ProcessNo) order by a.B_meaid
--联合tbl_a,tbl_b查询
select m.* , n.* from tbl_a m , (select a.* from tbl_B a where createDate = (select max(createDate) from tbl_B where ProcessNo = a.ProcessNo) order by a.B_meaid) n where m.a_meaid = n.b_meaid
select top 1 * from tbl_a a,tbl_b b
where a.a_meaid=b.b_meaid
and b.ProcessNo= 'NO1'
order by b.createDate desc