Stored Procedures & SQL : I'm doing some revision on SQL and I have a question that I'm trying to work out, I'm meant to be creating a stored procedure that displays all details of branch name, book code, and quantity on hand,the stored procedure takes paramater called @BranchName, I'm also meant to use EXEC to call this procedure with a value for the parameter.

This is my statement so far. **(I know that it's wrong and doesn't work some reason, I can't work it out)**

> CREATE PROCEDURE BranchDetails

> SELECT B.BookCode, BR.BranchName, I.OnHand

> FROM BOOK, BRANCH, INVENTORY

> WHERE BranchName = 'BookCode'