[Sybase][ODBC Driver][SQL Anywhere]Table 'tblRefCollectCentre' not found
SELECT cc.*, mgmtstatus, Status, FarmStatus, Race, state, district FROM tblRefCollectCentre cc,tblrefmgmtstatus ms, tblrefstatus s, tblRefFarmStatus fs, tblrefrace r, tblrefstate st, tblrefdistrict d WHERE CollectCentreCd='' AND cc.mgmtstatuscd = ms.mgmtstatuscd AND isnull(cc.StatusCd, '00')= s.StatusCd AND isnull(cc.FarmStatusCd, '00') = fs.FarmStatusCd and (isnull(cc.LeaderRaceCd, '00') = r.RaceCd ) and cc.StateCd = st.StateCd and (cc.StateCd = d. StateCd and cc.DistrictCd = d.DistrictCd)