以前3个表,我都用where,用join不知道怎么写select periodName,DeptName, convert( varchar(100), AppointTime, 23)AppointTime, app.*
from appointList app
join periodList per ,DeptList dl
on app.periodID=per.periodID and app.DeptID=dl.ID服务器: 消息 170,级别 15,状态 1,行 3
第 3 行: ',' 附近有语法错误。
from appointList app
join periodList per ,DeptList dl
on app.periodID=per.periodID and app.DeptID=dl.ID服务器: 消息 170,级别 15,状态 1,行 3
第 3 行: ',' 附近有语法错误。
select periodName,DeptName, convert( varchar(100), AppointTime, 23)AppointTime, app.*
from appointList app
join periodList per
on app.periodID=per.periodID
join DeptList dl
on app.DeptID=dl.ID这样写,结果出来。 这样写,规范吗?
就是这样
[/Quote]这个贴最后一问,4张表也可以照此类推了?select periodName,dlTo.DeptName DeptName,dlFrom.DeptName FromDeptName,convert( varchar(100), AppointTime, 23)AppointTime, app.*
from appointList app
left join periodList per
on app.periodID=per.periodID
left join DeptList dlTo
on app.DeptID=dlTo.ID
left join DeptList dlFrom
on app.FromDeptID=dlFrom.ID
inner join periodList per on app.periodID=per.periodID
inner join DeptList dl on app.DeptID=dl.IDselect periodName , DeptName , convert(varchar(20),AppointTime,23) AppointTime, app.* from appointList app
from appointList app , periodList per , DeptList dl
where app.periodID=per.periodID and app.DeptID=dl.ID
inner join periodList per on app.periodID=per.periodID
inner join DeptList dl on app.DeptID=dl.IDselect periodName , DeptName , convert(varchar(19),AppointTime,120), AppointTime, app.* from appointList app
from appointList app , periodList per , DeptList dl
where app.periodID=per.periodID and app.DeptID=dl.ID