Join tables

Queries can access multiple tables at once, or access the same table in such a way that multiple rows of the table are being processed at the same time. A query that accesses multiple rows of the same or different tables at one time is called a join query.

For example, to list all the weather records together with the location of the associated city, you might compare the city column of each row of the weather table with the name column of all rows in the cities table, and select the pairs of rows where these values match:

MYDB.SCHEMA(USER)=> SELECT * FROM weather, cities WHERE city = name;