SELECT *
FROM (SELECT DISTINCT REGISTERID,TOTALMONEY,RECIPESTATE,OPERATETIME,RECIPETYPE,DIAGNOSEID,REGISTEROFFICEID,DOCTORID,RECIPECONTENT,EXECOFFICEID,
RECIPESTATE,APPLYDOCNO FROM CLINICPHYSICIANRECIPE) A
left join T_PATIENT_INFO B on A.DIAGNOSEID=B.DIAGNOSEID
left join T_OFFICE C on A.REGISTEROFFICEID=C.OFFICEID
left join T_USERS D on A.DOCTORID=D.USERID
left join CLINICBRIEFEMR E on A.DIAGNOSEID=E.DIAGNOSEID and a.REGISTERID=E.REGISTERID
left join S_MEDORD_MAIN F on A.RECIPECONTENT=F.MEDORDID
left join T_OFFICE G on A.EXECOFFICEID=G.OFFICEID
left join C_SUBCATEGORY CS on F.SUBCATEGORY=CS.ID
left join C_CHECKLISTS CC on A.APPLYDOCNO=CC.CHECKLISTNO
WHERE A.RECIPETYPE='检查' AND A.RECIPESTATE=0 AND A.OPERATETIME>=CURRENT DATE - 15 DAYS
本人是小白,想咨询下大神,我的的语句是不是写的有问题?需要怎么写才能完成上述查询?
尝试将将(SELECT DISTINCT REGISTERID,TOTALMONEY,RECIPESTATE,OPERATETIME,RECIPETYPE,DIAGNOSEID,REGISTEROFFICEID,DOCTORID,RECIPECONTENT,EXECOFFICEID,
RECIPESTATE,APPLYDOCNO FROM CLINICPHYSICIANRECIPE) A,换成表的话,该语句无问题。但单独表无法满足小白需求
求大神指点。。。。