Hello, I am having one master table and three relational tables. These relational tables are connected with master table's primary key with foreign key. I want to join these four tables. But relational tables may be having values inside them or may be not or they contains some of ids from master table. I want to join these four tables with one query. How can I do this? Please help me. Thanks in advance.
Joining 4 tables is not harder than to join 2 tables, you just write the other joins as well. I think you need LEFT JOIN, look in the MySQL manual to see how it is used.
If you still need help please post the query you have created.
