SELECT RES_OBJECTESTAPPLYBILL2.PROJECTID, RES_OBJECTESTAPPLYBILL2.PROJECTNAME, RES_OBJECTESTAPPLYBILL2.FINISHSIGN
FROM RES_OBJECTESTAPPLYBILL2
WHERE RES_OBJECTESTAPPLYBILL2.FINISHSIGN = 1 and RES_OBJECTESTAPPLYBILL2.PROJECTNAME not in (select ERS_DIRECTOFFERMAIN.ProjectName from ERS_DIRECTOFFERMAIN)
ORDER BY RES_OBJECTESTAPPLYBILL2.PROJECTID