例如表a,b,c同时衫盯进行内连接,连接的key都是id字段select *from a inner join b on a.id = b.idinner join c on b.id = c.id其他情况如此类推,关或衫和键是看你的连接关系塌兄和连接的关键字
join可液模以做任意长度的链接,语闹春缓法是 a [left/right/inner...] join b on a.x=b.y [left/right/森备inner...] join c on c.z = b.r ....