Question

sql语句---查询结果作为表与其他表进行条件查询

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，换成表的话，该语句无问题。但单独表无法满足小白需求
求大神指点。。。。

Answer 1

既然没问题那就换成A，然后再从查询的结果集中找几列显示不就得了。还有A.OPERATETIME>=CURRENT DATE - 15 DAYS这个是什么鬼？