USE [cms] GO /****** Object: StoredProcedure [dbo].[SpGetRelatedProducts] Script Date: 10/10/2012 23:55:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter proc [dbo].[SpGetAllProducts](@cateid int) AS select * from product inner join subcategory on subcategory.subcate_id = product.subcate_id inner join category on subcategory.cate_id = @cateid
SELECT distinct * FROM product INNER JOIN subcategory ON subcategory.subcate_id = product.subcate_id INNER JOIN category ON subcategory.cate_id = @cateid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)