rA join operation brings together two tables by using a common field or a primary key and a foreign key. A typical example is to join attribute data from one or more nonspatial data tables to a feature attibute table for data query or analysis, such as the class example in Figure 8.10, where the two tables can the be joined by using the common field Soil-ID A to-m join operation is usually recommended for a one- to one or many-to-one relationship. Given a one- to one relationship, two tables are joined by record. Given a many-to-one relationship, many records in up t the origin have the same value from a record in the the destination. A join operation is inappropriate with the one-to-many or many-to-many relationship because only the first matching record value from the if the destination is assigned to a record in the origin