|
queryResult:select tblMRI.Id as HIDE_Id, tblLogin.LoginName as User, tblMRI.Date as Date, tblMRI.CustRef as CustRef, tblMRI.CustomerName as Customer_Name, tblMRI.Ref as Reference from tblMRI left join tblLogin on tblLogin.Id = tblMRI.UserId where ( tblMRI.Ref like '%%' or tblMRI.CustRef like '%%' or tblMRI.Id like '%%' ) and tblMRI.Type = 'Invoice' and tblMRI.Status > 0 and Month(tblMRI.Date) = '09' and Year(tblMRI.Date) = '2024' order by tblMRI.Id desc Table 'clttech_kailiAirconSG.tblMRI' doesn't exist |