A database table join links two database tables together so that their records are synchronized. A join has a “master” table and a “slave” table. The master table controls the slave table. As you move from row to row in the master table the slave table(s) will also move in a coordinated fashion.
A join consists of a master table and slave table linked by two columns common to both tables. There does not need to be a one-to-one correspondence of values in the columns (fields). However, if the slave table contains duplicate values in its “key” column then which row will be selected when the master table's key column is at that value is not certain.
GeoNetWeaver expects the topmost master table to be a shapefile and also control all other tables.
Any tables that are not controlled by the topmost table will effectively not contribute to the geoproject.