select a1.username,b1.orgname,a3.appTime leavetm ,a2.appTime overtm, from pub_user a1 left join f_attendApp a3 on a1.userid=a3.userid left join jiabansqd a2 on a2.userid=a1.userid left join pub_org b1 on b1.orgid=a2.orgid=a3.orgid where a2.processInsStatus !=9; 下面的语句怎么结合到上面的sql中一起查询出来? SELECT DATEDIFF(f.appTime,f1.appTime) AS sjhoho FROM jiabansqd f ,f_attendApp f1
两句sql 并为一句,怎么查出来?
我需要 下面两句sql并为一句查出数据啊。