Select * from orders inner join [user] on orders.username = [user].username inner join shop_songhuo on orders.deliverymethord = shop_songhuo.songid where orders.id = "&id&" and orders.state =3 or orders.edit = 2只能查询两个表,多个连接起来就不行? 不知是什么问题? 我在asp 网页上面的sql语句
还有orders和shop_songhuo 这样查就出错了
如果直接上面就 orders 和user表就没有问题