Using JOIN operator between the tables based on the related columns within each table
Like
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