SELECT TBE001.CPID, TBE001.ISSUERID, TBA001.ISSUERCODE, TBA001.COMPANYNAME, TBE001.PRICINGDATE as PRICINGDATE, TBE001.ISSUEDATE, TBE001.DUEDATE as DUEDATE, CAST([TBE001].[DUEDATE]-[TBE001].[ISSUEDATE] AS INT) AS TERM, TBE001.YIELD, TBE001.AMOUNT, TBE001.RandI, TBE001.JCR, TBE001.eCP, TBE001.CPDataSource, TBE001.ISSUERCODE AS IssuerCode_Box, TBE001.ISSUERNAME AS CompanyName_Box, TBE001.ISSUERNAME FROM TBE001 INNER JOIN TBA001 ON TBE001.ISSUERID = TBA001.ISSUERID ORDER BY PRICINGDATE, CompanyName_Box, DUEDATE;