Question

MySQL三表联查咋么查？

select * from table1 t1,table2 t2 where t1.id=t2.id
上面那个可以两表联查，如何修改可以三表联查

Answer 1

select * from table1 t1,table2 t2,table3 t3
where t1.id=t2.id and t1.id=t3.id