日期:2014-05-17 浏览次数:21047 次
SELECT PMWD.ID,(SELECT distinct PMWD.PJMBID FROM PM_PJMEMBER WHERE PM_PJMEMBER.PJMBID='106'), PMMB.PJMBNAME,PMWD.PJID ,PMWD.DELFLAG FROM PM_WORKDIARY PMWD LEFT JOIN PM_PJMEMBER PMMB ON PMWD.PJMBID=PMMB.PJMBID WHERE PMWD.DELFLAG='0'
SELECT PMWD.ID,PMWD.PJMBID, PMMB.PJMBNAME,PMWD.PJID ,PMWD.DELFLAG FROM PM_WORKDIARY PMWD LEFT JOIN PM_PJMEMBER PMMB ON PMWD.PJMBID=PMMB.PJMBID WHERE PMWD.DELFLAG='0' AND PMWD.PJMBID='106'