How to connected two or more table in MySQL

Answer 1

You can use JOIN for this, I assume you already know field references, here's some links for detailed information on JOIN:

https://www.w3schools.com/sql/sql_join.asp

https://www.tutorialspoint.com/sql/sql-using-joins.htm

Hth, cmiiw

Answer 2

You're welcome @Moe Ma Ka, glad to help.

Answer 3

Thankful lpang