不同方式用inner.txt

来自「SQL语言常用的一些命令各代码」· 文本 代码 · 共 37 行

CREATE TABLE A(部门 VARCHAR(10),  AID INT,     BID  INT, CID INT)
INSERT A  SELECT '生产'  ,1,        2  ,   3
UNION ALL SELECT '人力' , 2 ,       4 ,    5
UNION ALL SELECT '财务',  6  ,      3,     7

CREATE TABLE B(ID INT, Name VARCHAR(10))
INSERT B  SELECT 1,   '张三'
UNION ALL SELECT 2,   '李四'
UNION ALL SELECT 3,   '王五'
UNION ALL SELECT 4,   '赵六'
UNION ALL SELECT 5,   '大刚'
UNION ALL SELECT 6,   '金银'
UNION ALL SELECT 7,   '老九'

select * from a
select * from b







SELECT 部门,X.Name,Y.Name,Z.Name
	FROM A
INNER JOIN B X
	ON A.Aid=X.iD
INNER JOIN B Y
	ON A.Bid=Y.id
INNER JOIN B Z
	ON A.Cid=Z.id



select A.部门,max(case a.aid  when b.id then b.name end)as NAME,max(case a.bid  when b.id then b.name end)as NAME ,max(case a.cid  when b.id then b.name end) as NAME from a,b

group by A.部门