select
c.empno,c.empname,a.checkdate,b.detail
from
a
corss join
(select distinct empno,empname from b) c
left join
b
on
a.checkdate=b.checkdate and b.empno=c.empno
c.empno,c.empname,a.checkdate,b.detail
from
a
corss join
(select distinct empno,empname from b) c
left join
b
on
a.checkdate=b.checkdate and b.empno=c.empno
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货