Join enables you to make a new database by joining the current
database with another one.
It asks for another database to join with.
With
and
you can step through names
of databases you joined with earlier.
By typing TAB you can exit Join altogether.
When joining databases
and
, Jinx looks at the columns
with names that appear both in
and
.
The join-key of a record consists of the concatenation of such fields.
When join detects a record in
with a join-key that doesn't appear
in
it asks you whether you want to delete the record from
the join or to add empty data for the record.
You can also specify (with Delete) that such records must always
be left out of the join, or specify (with Add) that empty data
is to be added for all such records that may appear.
When join detects a record in
with a join-key
that appears more than once in
it asks you what to do.
You can specify that you wish to add all records of
in the join.
You can also specify (delete) to leave that record out of the join.
Alternatively, you can specify (Add) that such records in
must be
joined with all proper records in
, or specify (Delete)
that all such records in
should be left out of the join.
You may also choose show.
This option shows you the records in
that can be joined with.
You can then select a subset in various ways.
This is described in detail in the section on selection (2.3).
When join detects a record in the current database with zero
or more than one records in
to join with you may also exit
the entire join operation.
Deleted records don't take part in the join and are discarded.