SQL Add 2nd Most Recent Date From Another Table

[Bob Phillips]

You gonna like this, not a lot

SELECT A.FILE_NO
      ,DATE() - 1 AS Yesterday
	  ,A.BA_INT_RATE
	  ,(SELECT MAX(SystemDate) FROM SystemDate) AS systemDate 
	  ,(SELECT MAX(SystemDate) FROM SystemDate WHERE SystemDate < (SELECT MAX(SystemDate) FROM SystemDate)) AS systemDate1 
FROM Claim AS A 
WHERE A.STATUS_CODE = "OPN";