I have 4 tables “source”,”fields(fields for the source)”,”source_data”,”source_data_details”
How can I query it to make the result which contain all data of all tables at the same time
You can use multiple joins or aggregation. Here is an example using aggregation:
SELECT a.tutorial_id, a.tutorial_author, b.tutorial_count
-> FROM tutorials_tbl a LEFT JOIN tcount_tbl b
-> ON a.tutorial_author = b.tutorial_author;
Make sure each table contains ids to link each others