Create View Vw_Ac_Cash_Sales_2 (Ac_Cash_No,Name,Area_No,Rep_No ,Sale2015,Sale2016,Sal22017) As Select Ac_Cash_No,Name,(Select First 1 Area_no From Invoices I Where I.Ac_Cash_no=Vw_Ac.Ac_Cash_No Order By Inv_Date Desc ), (Select First 1 Rep_No From Invoices I Where I.Ac_Cash_no=Vw_Ac.Ac_Cash_No Order By Inv_Date Desc ),Sale2015,Sale2016,Sal22017 From Vw_Ac_Cash_Sales Vw_Ac