查询允许用户仅查看其产品
问题描述：
我有一个表，用于包含itemid，itemname的项目，另一个用于权限，其中包含userid，itemid.现在，我只想向用户显示那些在用户权限中已授予他许可的产品.它在userlogin和userid上存储在Session中.
I have one table for items which contain itemid,itemname , another for permission which contain userid,itemid. Now i want to show the user only those products whose permission given to him in the userpermission. Its on the userlogin and userid is stored in Session .
答
我假设您需要sql部分
I assume you need the sql part
SELECT
*
FROM
Item_Table it
JOIN
Permission_Table pt
ON
it.itemid = pt.itemid
WHERE
pt.userid = @userId