Joins

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. 

Share This Page

FACEBOOK COMMENTS WILL BE SHOWN ONLY WHEN YOUR SITE IS ONLINE

©Elephant Software Klaudiusz Wojtkowiak
e-mail: contact@daobab.io