JOINsyntax provides methods of combining information in tables.
JOINs are supported.
A join may be performed as a
NATURAL JOINor where the conditions for the join are more explicitly specified.
The different ways in which the various join options can be combined makes the overall
JOINsyntax quite convoluted, so to simplify the explanation, each variant will be described on its own with an accompanying syntax diagram.
In order to understand the
JOINsyntax generally, it is important to appreciate the difference between an
JOIN. It is also important to be aware of the three fundamental
JOIN ON) which are mutually exclusive and apply equally to
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40