Answer to Question #7702 in Databases | SQL | Oracle | MS Access for keizy

Question

hi i need help i need to create table using combinations of Cursors, Loops, Inserts, Variables, If-Else conditions that will display a table below
Employee Name Customer ID Order ID Order Date Order Amount Running Total
Employee 1 Customer 1 Order 1 1/1/2000 2,500 2,500
Order 2 1/1/2000 3,000 5,500
Order 3 1/1/2000 5,000 10,500

Customer 2 Order 4 1/2/2000 500 500
Customer 3 Order 5 1/2/2000 500 500
Order 6 1/3/2000 500 1,000

Employee 2 Customer 1 Order 7 1/1/2005 900 900
Customer 5 Order 8 1/2/2005 1,500 1,500
Order 9 1/3/2005 2,000 3,500