请问 INNER JOIN 是什么意思？

[programtime]

SELECT C.ID, CoID
FROM table1 AS C INNER JOIN table2 AS N
ON C.ID = N.ID
WHERE Time >= @dtStart and Time < @dtEnd

请问上面的SQL语句是什么意思？“ INNER JOIN table2 AS N
ON C.ID = N.ID ”这块我看不懂，请教。

[songtao368]

inner join就是 select * from a,b where a.col1 = b.col2
如果不明白看联机帮助

[gotoitcn]

全连接

[yesterday2000]

看联机帮助
此内联接称为相等联接。它返回两个表中的所有列，但只返回在联接列中具有相等值的行

[rouqu]

inner join就是
select * from a,b where a.col1 = b.col2

[MY128]

1、内连接查询
select thj0302,thj2403,thj2404,thj2405,thj3601,thj0303,THJ0301 from thj03
INNER join THJ24 on thj2401=thj0300

它会从thj03的表里面找出符合thj2401=thj0300这个备件的记寻

[MY128]

:(不好意思，不是‘备件’是‘条件’

[Andy__Huang]

SELECT a.ID,b.name FROM table1 a INNER JOIN table2 b ON a.ID = b.ID
SELECT a.ID,b.name FROM table1 a,table2 b where a.ID = b.ID
上面兩句是一樣的。