#### Equal [=] join

The result set from an Equal join includes all the records where the linked field value in both tables is an exact match. In the following example, the Customer table is linked to the Orders table by the Customer ID field. When the program finds a Customer ID in the Orders table that matches a Customer ID in the Customer table, it displays information for the corresponding records in both tables.

SQL uses the following syntax to describe an Equal join:

    SELECT Customer.'Customer ID',
        Customer.'Customer Name',
        Orders.'Order Amount'
    FROM 'Customer' Customer,
        'Orders' Orders
    WHERE Customer.Customer ID =
        Orders.Customer ID

This statement produces the following data:

Customer Table | Customer Table | Orders Table
--- | --- | ---
Customer ID | Customer Name | Order Amount
52 | Allez Distribution | 25141.50
53 | BG Mountain Inc. | 19164.30
53 | BG Mountain Inc. | 1683.60
57 | Hansen MTB Inc. | 15716.40
58 | La Bomba de Bicicleta | 1956.20
60 | Mountain Toad | 24580.50
62 | SFB Inc. | 7911.80
63 | Sierra Bicycle Group | 19766.20
63 | Sierra Bicycle Group | 12763.95
64 | Sierra Mountain | 8233.50

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com