关联表的语句错误，帮忙看一下啊(30分)

Y

yulswa

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-28

• #1

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'.

 

K

Kisber

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-28

• #2

select a.*, m.* from ... as a inner join ... as m on m.key = a.key
--------------
inner join 必须有 on 条件！
cross join 才无须条件。[]

 

C

china_peng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-28

• #3

SELECT TABA.A01,TABA.AO2,TABB.B01,TABB.B02 FROM TABA INNER JOIN TABB ON
(TABA.A01=TABB.B01)