select * from UserDepart a left join UserSubDepart b on a.ID=b.DepartId left join UserTelephone c on b.SubDepart =c.Depart order by b.DepartId,b.Depart1
select t1.* , t2.* , t3.* from UserDepart t1 , UserSubDepart t2 , UserTelephone t3 where t1.ID = t2.DepartId and t2.ID = t3.SubDepart --这里看不懂你的关联条件,自己补全 order by t1.depart , t2.Depart1
SQL2000升级到2005,这个查询就不好使了,请问怎么回事?原sql2000语句: SELECT CONVERT(varchar(20), a.id) + '_' + CONVERT(varchar(20), a.colid) AS FID, a.id AS FTableID, b.name AS FTableName, a.colid AS FColID, a.name AS FColName, c.value AS FColDesc, a.xtype AS FTypeID, d.name AS FTypeDesc, a.length AS FLength FROM sys.syscolumns AS a INNER JOIN sys.sysobjects AS b ON b.id = a.id AND b.xtype = 'U' AND b.status > 0 LEFT OUTER JOIN dbo.sysproperties AS c ON c.id = a.id AND c.smallid = a.colid AND c.type = 4 LEFT OUTER JOIN sys.systypes AS d ON d.xtype = a.xtype求好使的语句
SELECT A.ID, A.depart, B.Depart1, C.UserName, C.Telephone, C.DateTime FROM UserDepart A INNER JOIN UserSubDepart B ON A.ID = B.DepartId INNER JOIN UserTelephone C ON B.ID = C.Depart ORDER BY A.ID, B.Depart1
不对 有问题 我把表关系弄出来吧 单位 A, B , C, ...... 部门 a , b , c a, b , c a, b, c 每个部门id独立 靠,[DepartId] 与单位关联 人员1,2,3,1,2,3 1,2,3 1,2,3 1,2,3 1,2,3 1,2,3 1,2,3 1,2,3 是这样的 用左连接的话 就会出现问题 一个单位有多个部门 一个部门有多个人
left join UserSubDepart b on a.ID=b.DepartId
left join UserTelephone c on b.SubDepart =c.Depart
order by b.DepartId,b.Depart1
from UserDepart t1 , UserSubDepart t2 , UserTelephone t3
where t1.ID = t2.DepartId and t2.ID = t3.SubDepart --这里看不懂你的关联条件,自己补全
order by t1.depart , t2.Depart1
SELECT CONVERT(varchar(20), a.id) + '_' + CONVERT(varchar(20), a.colid) AS FID, a.id AS FTableID, b.name AS FTableName, a.colid AS FColID,
a.name AS FColName, c.value AS FColDesc, a.xtype AS FTypeID, d.name AS FTypeDesc, a.length AS FLength
FROM sys.syscolumns AS a INNER JOIN
sys.sysobjects AS b ON b.id = a.id AND b.xtype = 'U' AND b.status > 0 LEFT OUTER JOIN
dbo.sysproperties AS c ON c.id = a.id AND c.smallid = a.colid AND c.type = 4 LEFT OUTER JOIN
sys.systypes AS d ON d.xtype = a.xtype求好使的语句
A.ID,
A.depart,
B.Depart1,
C.UserName,
C.Telephone,
C.DateTime
FROM UserDepart A
INNER JOIN UserSubDepart B
ON A.ID = B.DepartId
INNER JOIN UserTelephone C
ON B.ID = C.Depart
ORDER BY A.ID, B.Depart1
单位 A, B , C, ......
部门 a , b , c a, b , c a, b, c 每个部门id独立 靠,[DepartId] 与单位关联
人员1,2,3,1,2,3 1,2,3 1,2,3 1,2,3 1,2,3 1,2,3 1,2,3 1,2,3
是这样的 用左连接的话 就会出现问题
一个单位有多个部门 一个部门有多个人
如果有多表,表之间如何关联?
如何更有效地在SQL Server论坛上提问
http://topic.csdn.net/u/20100716/19/6f132f16-20e4-418c-8dee-b99d5f86d320.html?75910
select t1.depart , t2.Depart1 , t3.Id, t3.UserName, t3.Telephone, t3.DateTime
from UserDepart t1 , UserSubDepart t2 , UserTelephone t3
where t1.ID = t2.DepartId and t2.ID = t3.SubDepart and t3.isok=0
order by t1.depart desc, t2.Depart1 desc