Join



next up previous contents
Next: Order Up: The meta-menu Previous: Project

Join

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.



next up previous contents
Next: Order Up: The meta-menu Previous: Project



LOTOS TOOLS in TWENTE
Fri Oct 7 13:30:15 MET 1994