If you have a relation/common columns in a different tables, you can use joins in your query to get the result.