三个表连接的问题？

[bihu]

select *
FROM TABLE1 INNER JOIN TABLE2 ADN TABLE3 ON TABLE1.ID=TABLE2.ID AND TABLE2.ID=TABLE3.ID
这样写是否有错？

[IT写轮眼]

select * from
table1 inner join table2 on table1.id=table2.id and table2 inner join table3 on
table2.id=table3.id

• 打赏
• 举报

回复 赞

[lazywolf]

select *
FROM TABLE1 INNER JOIN TABLE2 ADN TABLE3 ON TABLE1.ID=TABLE2.ID on TABLE2.ID=TABLE3.ID

• 打赏
• 举报

回复 赞