http://www.for.gov.bc.ca/pscripts/his/apb/index.asp Bulletins for the last 14 day regarding Ministry of Forests and Range computer applications, systems and networks. Copyright 2009, Province of British Columbia en-ca Tue, 24 Nov 2009 12:00:00 PST http://www.for.gov.bc.ca/images/forser1.gif http://www.for.gov.bc.ca/pscripts/his/apb/index.asp 68 87 SELECT b.RecordID, b.Title, b.Access, b.Abstract, b.dtPosted, a.Acr, a.App, s.Subject FROM tbSubject s INNER JOIN ( tbApp a INNER JOIN tbAPB b ON a.AppID = b.AppID ) ON s.SubjectID = b.SubjectID WHERE ( b.dtExpired > now() ) AND b.dtPosted > #11/10/2009# AND a.AppID = 5 AND b.Access = 'PA' ORDER BY b.dtPosted DESC, b.RecordID DESC;