Create SP like ...
CREATE PROCEDURE db.GetProducts
(
@City VARCHAR(200)
,@ShoppingCentre VARCHAR(200)
)
AS
BEGIN
SET NOCOUNT ON;
SELECT Customer. Behcode,Customer.Name AS CustomerName
, Customer.City,Customer.Shoppingcenter
,Product.Name AS ProductName, Description, Image
FROM Customer LEFT OUTER JOIN Product ON Customer.Behcode = Product.Behcode
WHERE LOWER(Customer.city)= LOWER(@City) AND LOWER(Customer.Shoppingcenter) = LOWER(@@ShoppingCentre)
END