Stored procedure ornegi.. ..

create   proc [dbo].[getProductByid]
@code nvarchar(50)
AS

select productid  ,c.catname, b.barkodCode, name,price,stok
from tbl_products
INNER JOIN dbo.tbl_productCatList c
on   tbl_products.catid =  c.catid
INNER JOIN tbl_barkods b
on  tbl_products.barkodid = b.barkodid
where b.barkodCode = @code