How can I implement a query to display data by using 3 tables data which are depend on each other?

Using JOIN operator between the tables based on the related columns within each table


This is just a stub for illustration. In the actual case the nature of join applied (INNER, LEFT OUTER ,RIGHT OUTER, FULL,…) depends on your exact use case.

We can use subqueries, with queries also to do the same task