有四个表WS_jjgz, WS_Employee, bm, WS_GX
WS_jjgz字段(j):ID NAME ry_id bm_id gx_id
-------------------------
1 a 1 2 3
1 a 1 2 3
...........WS_Employee字段(e):ID NAME
-------
1 a
1 a
...........bm字段(e):ID NAME
-------
1 a
1 a
...........WS_GX字段(g):ID NAME
-------
1 a
1 a
...........我想实现如下显示效果:j.ID j.NAME e.NAME g.NAME b.NAME
----------------------------------
1 a a a a
1 a a a a
1 a a a a
.............下面语错在哪里了啊??
新手请求帮助,在线求sql语句
select j.NAME,e.NAME,b.NAME,g.NAME from WS_jjgz j join WS_Employee e on j.ry_id = e.ID join bm b on j.bm_id = b.ID join WS_GX g on j.gx_id = g.ID
WS_jjgz字段(j):ID NAME ry_id bm_id gx_id
-------------------------
1 a 1 2 3
1 a 1 2 3
...........WS_Employee字段(e):ID NAME
-------
1 a
1 a
...........bm字段(e):ID NAME
-------
1 a
1 a
...........WS_GX字段(g):ID NAME
-------
1 a
1 a
...........我想实现如下显示效果:j.ID j.NAME e.NAME g.NAME b.NAME
----------------------------------
1 a a a a
1 a a a a
1 a a a a
.............下面语错在哪里了啊??
新手请求帮助,在线求sql语句
select j.NAME,e.NAME,b.NAME,g.NAME from WS_jjgz j join WS_Employee e on j.ry_id = e.ID join bm b on j.bm_id = b.ID join WS_GX g on j.gx_id = g.ID
from WS_jjgz j inner join WS_Employee e on j.ry_id = e.ID
inner join bm b on j.bm_id = b.ID
inner join WS_GX g on j.gx_id = g.ID--join 换成 inner join
j.ID=j.ID,
j.NAME=j.NAME,
e.NAME=e.NAME,
b.NAME=b.NAME,
g.NAME=g.NAME
from
WS_jjgz j
inner join
WS_Employee e
on
j.ry_id = e.ID
inner join
bm b
on
j.bm_id = b.ID
inner join
WS_GX g
on
j.gx_id = g.ID
试试看!
insert into #WS_jjgz select 1,'a',1,2,3
insert into #WS_jjgz select 1,'a',1,2,3
gocreate table #WS_Employee(id int,name char(4))
insert into #WS_Employee select 1,'a'
insert into #WS_Employee select 1,'a'
gocreate table #bm(id int,name char(4))
insert into #bm select 1,'a'
insert into #bm select 1,'a'
gocreate table #WS_GX(id int,name char(4))
insert into #WS_GX select 1,'a'
insert into #WS_GX select 1,'a'
goselect j.id,j.NAME,e.NAME,g.NAME,b.NAME from
#WS_jjgz j,#WS_Employee e,#bm g,#WS_GX b
where
j.id=e.id and e.id=g.id and g.id=b.id and b.id=j.id
select j.NAME,e.NAME,b.NAME,g.NAME
from WS_jjgz j inner join WS_Employee e on j.ry_id = e.ID
inner join bm b on j.bm_id = b.ID
inner join WS_GX g on j.gx_id = g.ID--join 换成 inner join-------------------------------应该是正解了
FROM ws_jjgz j
INNER JOIN ws_employee e
ON j.ry_id = e.id
INNER JOIN bm b
ON j.bm_id = b.id
INNER JOIN ws_gx g
ON j.gx_id = g.id
,WS_GX from ((WS_jjgz inner join WS_jjgz on
ws_jjgz.ry_id=ws_jjgz.id) inner join bm on ws_jjgz.bm_id=bm.id) inner join ws_gx on ws_jjgz.gx_id=ws_gx.id;
这样,试试
如果行,加分
FROM ws_jjgz j
INNER JOIN ws_employee e
ON j.ry_id = e.[id]
INNER JOIN bm b
ON j.bm_id = b.[id]
INNER JOIN ws_gx g
ON j.gx_id = g.[id]
select j.NAME,e.NAME,b.NAME,g.NAME
from ((WS_jjgz j inner join WS_Employee e on j.ry_id = e.ID)
inner join bm b on j.bm_id = b.ID)
inner join WS_GX g on j.gx_id = g.ID
结贴,谢谢大家