Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

Joining tables in GIS is one of the most useful and common methods for GIS analysts. It is used to join two or more tables based on the same attribute, which is called the primary key.