CREATE PROCEDURE dbo.OnlineOwnerInetProduct @ACustomernumber INT AS
SET NOCOUNT ON
/*
    Created by Troels Buch Juni 2008

    Changes: N/A
vgh

    NOTES: 	- 

*/

SELECT Customer.Customernumber, Firstname, Lastname, Address1, Address2, ZipcodeOverwrite, Cityoverwrite,
Products.ProductNumber, Products.productname, Products.CustomerRate, Products.Description
FROM Customer WITH (nolock) INNER JOIN CustomerFieldsPerHotel WITH (NOLOCK) ON CUSTOMER.CustomerNumber = CustomerFieldsPerHotel.CustomerNumber INNER JOIN
Products WITH (NOLOCK)  ON Products.ProductNumber = CustomerFieldsPerHotel.OvernightProductNumber6 
WHERE Customer.Customernumber = @ACustomernumber
AND Customer.MARKASDELETED <> 1
GO
