Mysql Select Query Get Data From Row Based

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

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments