SELECT TRClient.TRC_Date,TRClient.TRC_Credit,TRClient.TRC_Versement, (TRClient.TRC_Credit)-(TRClient.TRC_Versement)as TRC_Balance from TRClient where TRClient.TRC_IDClient = 1 Order By TRClient.TRC_date