SELECT ca.iCAYId, a.dFromPeriod, a.dToPeriod FROM client_accountyear ca LEFT JOIN mas_accountyear a ON ca.iAccountYearId=a.iAccountYearId WHERE (ca.dAccountStart='0000-00-00' OR ca.dAccountEnd='0000-00-00') ORDER BY ca.iCAYId ASC<hr /><hr /><hr />No records found!