在我的查询的下一个步骤中,真的在寻找帮助。我不是一个开发人员,我的老板没有给我压力,我的工作也没有危险。我只是一个初学者,一个普通的家伙,挣扎在mySQL/PHP的深渊,寻找一些支持。我没有解决我的问题的知识或经验,因此我已经张贴在这里。SELECT typeName, COUNT(bedID) AS count, pRed, pAmber, pGreen, dRed, dAmber, dGreen, sRed, sAmber, sGreenJOIN hotel on hotelID = bedHotelID
JOIN type ON typeI
= A2.WEEK_MINUS_1_PERF_RAG) or ((A1.WEEK_MINUS_1_PERF_RAG is null) and (A2.WEEK_MINUS_1_PERF_RAG is= A2.WEEK1_PERF_RAG) or ((A1.WEEK1_PERF_RAG is null) and (A2.WEEK1_PERF_RAG is null)))= A2.WEEK2_PERF_RAG) or ((A1.WEEK2_PERF_RAG