So would the script look like this?

SELECT *FROM (SELECT * FROM sys.objects) AS SalesStats

GO

SELECT OldDealerID,

[A] AS Approved,

AS Conditioned,

[D] AS Declined

FROM (SELECT OldDealerID, AppDetails.AppID,...

As much as I have tried to make this stupid thing work, it is not working. I still keep getting the same error. The sorry thing is that...

Where am I going wrong with this?

SELECT OldDealerID,

[A] AS Approved,

AS Conditioned,

[D] AS Declined

FROM (SELECT OldDealerID, AppDetails.AppID, [Status]

...