Joins using more than two tables

How to join one table开发者_运维知识库 with more than two tables?

---

This might be what you are looking for.

select * from Table1 a
join table2 b on (a.column = b.column)
join table3 c on (a.column = c.column)

But I suggest you pick up a tutorial on how to write queries to decrease downtime on basic statements.

---

SELECT * FROM a JOIN b JOIN c JOIN d

This will do a cartesian product because there is no join conditions, but a has been joined with three tables. Maybe your question needs to be more specific.

---

select * from table1 a,table2 b,table3 c where a.col=b.col and a.col=c.col