多表查询join left问题

[TaoTaoYou]

Sql = "Select * From Sell_Item_List as a left join Server_Item as b on a.Item_class=b.id left join Staff_Info on a.Staff_no = Staff_Info.Staff_no"



提示语法错误..操作符丢失

[htl258_Tony]

SQL语法正确.

[SQL77]

[Quote=引用楼主 taotaoyou 的回复:]
Sql = "Select * From Sell_Item_List as a left join Server_Item as b on a.Item_class=b.id left join Staff_Info on a.Staff_no = Staff_Info.Staff_no"


提示语法错误..操作符丢失
[/Quote]
语法没问题呀,是在程序中提示的?

[jinjazz]

access？

[xiequan2]

Select * From Sell_Item_List as a left join Server_Item as b on a.Item_class=b.id left join Staff_Info on a.Staff_no = Staff_Info.Staff_no
对的

[sdhdy]

把这个语句，在查询分析器执行看看。

[SQL77]

[Quote=引用 3 楼 jinjazz 的回复:]
access？
[/Quote]
呵呵,可能真的不是SQL数据库

[让你望见影子的墙]

语法貌似无问题

[TaoTaoYou]

是access该咋办?

[jinjazz]

Select * From Sell_Item_List as a
left join (
Server_Item as b left join Staff_Info on a.Staff_no = Staff_Info.Staff_no)
on a.Item_class=b.id

加括号

[TaoTaoYou]

[Quote=引用 9 楼 jinjazz 的回复:]
Select * From Sell_Item_List as a
left join (
Server_Item as b left join Staff_Info on a.Staff_no = Staff_Info.Staff_no)
on a.Item_class=b.id

加括号
[/Quote]

join操作语法错误

[SQL77]

[Quote=引用 10 楼 taotaoyou 的回复:]
引用 9 楼 jinjazz 的回复:
Select * From Sell_Item_List as a
left join (
Server_Item as b left join Staff_Info on a.Staff_no = Staff_Info.Staff_no)
on a.Item_class=b.id

加括号


join操作语法错误
[/Quote]
去ACCESS问下

[jinjazz]

反正access的规则就是

select * from (a left join b on a.a=b.a) left join c on a.c=c.c
--
我写错了，应该把表放到括号里

Select * From
(Sell_Item_List as a left join Server_Item as b on a.Item_class=b.id)
left join Staff_Info on a.Staff_no = Staff_Info.Staff_no

[TaoTaoYou]

谢谢...已解决