create procedure getInvoiceInfoById
(@invoiceNumber int)
as
SELECT     Invoice.InvoiceNumber, Invoice.MemberID, Member.LastName + ', ' + Member.FirstName AS Name, Member.Address, Invoice.InvoiceDate AS Date, 
                      PaymentType.Description AS Payment, Invoice.SubTotal, Invoice.GST, Invoice.Total, Product.Description AS ProductName, InvoiceDetail.Quantity, 
                      InvoiceDetail.Price
FROM         Invoice INNER JOIN
                      InvoiceDetail ON Invoice.InvoiceNumber = InvoiceDetail.InvoiceNumber INNER JOIN
                      Member ON Invoice.MemberID = Member.MemberId INNER JOIN
                      PaymentType ON PaymentType.PaymentTypeID = Invoice.PaymentTypeID INNER JOIN
                      Product ON InvoiceDetail.ProductID = Product.ProductID
						where invoice.invoiceNumber=@invoiceNumber
return @@error