34,838
社区成员




select a.u_name 管理员,b.u_name 消费者,c.u_name 商家,p.p_count 数量
from product p,[user] a,[user] b,[user] c
where p.p_userid=a.u_id and p.p_consumerId=b.u_id and p.p_businesses=c.u_id
--创建user表
CREATE TABLE #USER(u_id INT,u_name NVARCHAR(10))
--插入user表数据
INSERT INTO #USER
SELECT 1,'张三'
UNION ALL
SELECT 2,'李四'
UNION ALL
SELECT 3,'王五'
--创建product表
CREATE TABLE #product(p_id INT,p_userid INT,p_consumerId INT,p_businesses INT,p_count INT)
--插入product表数据
insert into #product
SELECT 1,1,2,3,100
UNION ALL
SELECT 2,1,3,2,200
SELECT a1.u_name 管理员,a3.u_name 商家,a2.u_name 消费用户,p.p_count
FROM #product p,#USER a1,#USER a2,#USER a3 WHERE
p.p_userid = a1.u_id
AND p.p_consumerId = a2.u_id
AND p.p_businesses = a3.u_id
select a.u_name 管理员,b.u_name 消费者,c.u_name 商家,p.p_count 数量
from product p,[user] a,[user] b,[user] c
where p.p_userid=a.u_id and p.p_consumerId=b.u_id and p.p_businesses=c.u_id