Use SQL joins in PostgreSQL At this point, we are going to create and run a query against multiple tables using join clauses, almost always inner join clauses (the default).