In general querying, we saw how to work with single table. Now let’s explore how to work with multiple tables. When we want to retrieve data from more than one tables from database, joins are used to collect required columns data in a single query. Joins are heavy and slower than plain queries but phoenix supports many configurations and hints to fine tune your join query performance for faster results. We will discuss them in this chapter while explaining join optimizations section.