If you have 3 Tables, Table1, Table2, Table3 and you want some data from Table1 , some from Table2, and some from Table3 then follow below sql query using JOIN.
Here is a example, If you have 3 tables named : township, society, block then you want
You can simply add another join like this:
FROM block t1
INNER JOIN society t2
ON (t1.soc_id = t2.id)
INNER JOIN township t3
ON (t2.soc_township = t3.id)
Related Searches for How to use multiple join in mysql
Can you do multiple joins in SQL?How many joins can you have in SQL?How does multiple inner join works?How optimize SQL query with multiple joins?Can I join three tables in SQL?Can I join Multiple columns in SQL?How optimize SQL query join?Joining three or more tables in SQL eeksforGeeksSQL multiple joins for beginners with examplesCombining multiple joins | Relational queries in SQLHow to join three tables in SQL queryHow to use multiple joins in sql?How to left join two tables in sql?How to natural join three tables in sql?How to join 3 tables in sql server?Can you join on multiple columns in sql?What is the most common type of join in sql?
SQL joins and how to use them – Launch SchoolSQL JOIN