select PW.PMId,Concat(P.Name,PM.Name) PrintMatterName,PM.Size,PM.PageAmount,PM.PrintAmount, E.Name Charge,PM.FinishDate,P.OrderDate,PM.Memo from WorkLog WL,PMWN PW,PrintingMatter PM,WorkNode WN,Project P,Employee E Where PW.Id=WL.PMWNId and PM.Id=PW.PMId and WN.Id=PW.WNId and P.Id=PM.ProjectId and E.Id=PM.Charge and TO_DAYS(NOW())-TO_DAYS(WL.OutTime)=0 加上最后一句就有问题
当结果集为空时,就有错,而正常情况时没问题的
有谁遇到过这样的问题吗,帮帮我,它烦了我几天了
E.Name Charge,PM.FinishDate,P.OrderDate,PM.Memo
from WorkLog WL,PMWN PW,PrintingMatter PM,WorkNode WN,Project P,Employee E
Where PW.Id=WL.PMWNId and PM.Id=PW.PMId and WN.Id=PW.WNId and P.Id=PM.ProjectId
and E.Id=PM.Charge and TO_DAYS(NOW())-TO_DAYS(WL.OutTime)=0
加上最后一句就有问题