Easy way to query over many tables.

Join by the same column
- when first and second table have the same column

This is the simplest the most popular join method.

By default Inner Join is in use, but you may change it:

If you want to join by different methods, just specify them like this:

It's even shorter way to join by Primary Key (assuming first table has a Foreign Key to this table)

Above joins may be combined with where clause:

Using Where clauses together with Join, introduces order into the query. Especially in the case of joining many tables.
Those kinds of queries are also very efficient. 

© Copyright 2018-2023 Elephant Software Klaudiusz Wojtkowiak