79分求SQL语句（不太难）
原语句是2个表连接，可正常使用
strSQL = "SELECT 表A.item_no, " & _
"表B.item_no " & _
" FROM 表A INNER JOIN表B " & _
" ON 表A.item_no=表B.item_no " & _
" WHERE ...... "
现增加了一个表，共3个表要连接，连接的条件是3个表中的item_no字段都相同，
请问怎样写连接语句，谢谢！
strSQL = "SELECT 表A.item_no, " & _
"表B.item_no, " & _
"表C.item_no " & _
" FROM 表A INNER JOIN表B ......
[解决办法]
strSQL = "SELECT 表A.item_no, " & _
"表B.item_no, " & _
"表C.item_no " & _
" FROM (表A INNER JOIN表B ON 表A.item_no=表B.item_no) inner join 表C on 表A.item_no=表c.item_no...... "
[解决办法]
strSQL = "SELECT 表A.item_no, 表B.item_no, 表C.item_no " & _
" FROM 表A " &_
" INNER JOIN 表B ON 表A.item_no=表B.item_no " & _
" INNER JOIN 表C ON 表A.item_no=表C.item_no " & _
" WHERE ...... "
[解决办法]
strsql= " select a.item_no,b.item_no,c.item_no from 表A as a,表B as b,表C as c where a.item_no=b.item_no and a.item_no=c.item_no "
[解决办法]
楼上正解
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码)
http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html
