关联表的语句错误，帮忙看一下啊
sql语句如下：
select *
from caiwu_shoukuan as a inner join a_JB_yewu as m
其中两个表都存在
错误：
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near 'm'.
问题点数：30、回复次数：5Top
1 楼zswang（伴水清清)(专家门诊清洁工）回复于 2001-12-28 15:37:55 得分 10
select *
from caiwu_shoukuan as a inner
join
select *
from a_JB_yewu as m
Top
2 楼big_net（jasonking）回复于 2001-12-28 15:41:46 得分 0
不行，我用的query控件
还是出现错误：
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'select'.Top
3 楼zwhhwz（zhi）回复于 2001-12-28 16:15:11 得分 10
select *
from caiwu_shoukuan as a inner join a_JB_yewu as m
缺少条件 比如on a.Field1 = m.Field2Top
4 楼V_Lucky（最优解）回复于 2001-12-28 16:18:22 得分 10
select *
from caiwu_shoukuan as a inner join a_JB_yewu as m
on a.xxx=m.xxxTop
5 楼big_net（jasonking）回复于 2002-01-04 14:50:54 得分 0
给分了－Top
