Ask a New Question

I have created a Database called Business with the 2 tables as follows:

dbo.Orders
ID
OrderID
ItemName
Quantity
Price
SalesID

dbo.Sales
SalesID
FIrstName
LastName
OrderID

I need to create a stored procedure to show Total Sales of each sales, including SalesID, FirstName, LastName, Total Sales.

Ask a New Question or answer this question.

Similar Questions

I have created a Database called Business with the 2 tables as follows:dbo.Orders ID OrderID ItemName Quantity Price SalesID
1. 0 answers
A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a
1. 0 answers
Create a database using PHPMyAdmin and name the database ClothingStore. The databasemay consist of the following tables: 
1. 3 answers
Create a database using PHPMyAdmin and name the database ClothingStore. The databasemay consist of the following tables: 
1. 1 answer

more similar questions