菜鸟！一句select语句不明白，想不通！

[ballatong]

有两张表：table1

sc
B4B037900
B4B077800
B4B083000
B4B083100

table2

ordno
B4B037900
B4B077800
B4B083000
B4B083100
－－－－－－－－－－－－－－－－－－－－－
用语句


select * from table1 a INNER JOIN

table2 c ON a.ordno = c.sc#



请问产生的结果为什么是 13行！


B4B037900
B4B077800
B4B037900
B4B077800
B4B083000
B4B083100
B4B083000
B4B083000
B4B083100
B4B037900
B4B077800
B4B083000
B4B083100

－－－－－－－－－－－－应该4行才对啊！

[ballatong]

select * from table2 a INNER JOIN

table1 c ON a.ordno = c.sc#

[vinsonshen]

select a.ordno,c.sc from table2 a INNER JOIN

table1 c ON a.ordno = c.sc#

[vinsonshen]

select * from table2 a INNER JOIN

table1 c ON a.ordno = c.sc

[hzwm]

结果应该是四行，没错。

select a.*
from table1 a , table2 b
where a.sc =b.ordno

[didoleo]

同意楼上,就是返回四行嘛,哪来的13行?

[火电]

是啊
select * from table2 a INNER JOIN

table1 c ON a.ordno = c.sc#
是标准的join写法



select a.*
from table1 a , table2 b
where a.sc =b.ordno

是从前的join写法
都没有问题

[ballatong]

那就奇怪了 我的返回13行！