我有三张表,需要内联
use weboa
go
select Sys_Employee.id,Sys_Employee.eName,Sys_Item.ItemName,Sys_Item.ItemPlace,Sys_DicPosition.PositionName from Sys_Employee
inner join Sys_Item inner join Sys_DicPosition
on Sys_Employee.eProId=rtrim(Sys_Item.ItemId) and Sys_Employee.ePosition=str(Sys_DicPosition.id)我的语句如上,但是出错了,请问怎么改?
use weboa
go
select Sys_Employee.id,Sys_Employee.eName,Sys_Item.ItemName,Sys_Item.ItemPlace,Sys_DicPosition.PositionName from Sys_Employee
inner join Sys_Item inner join Sys_DicPosition
on Sys_Employee.eProId=rtrim(Sys_Item.ItemId) and Sys_Employee.ePosition=str(Sys_DicPosition.id)我的语句如上,但是出错了,请问怎么改?
inner join Sys_Item inner on Sys_Employee.eProId=rtrim(Sys_Item.ItemId)
join Sys_DicPosition on Sys_Employee.ePosition=str(Sys_DicPosition.id)
use weboa
go
select
Sys_Employee.id,Sys_Employee.eName,Sys_Item.ItemName,Sys_Item.ItemPlace,Sys_DicPosition.PositionName from Sys_Employee
inner join Sys_Item on Sys_Employee.eProId=rtrim(Sys_Item.ItemId)
inner join Sys_DicPosition on Sys_Employee.ePosition=str(Sys_DicPosition.id)
go
select Sys_Employee.id,Sys_Employee.eName,Sys_Item.ItemName,Sys_Item.ItemPlace,Sys_DicPosition.PositionName from Sys_Employee
inner join Sys_Item on Sys_Employee.eProId=rtrim(Sys_Item.ItemId)
inner join Sys_DicPosition
ON Sys_Employee.ePosition=str(Sys_DicPosition.id)每次一个条件