#### Greater Than Or Equal [>=] join

The result set from a Greater Than Or Equal join includes all records in which the linked field value in the primary table is greater than or equal to the linked field value in the lookup table. The example here is identical to the example for the Greater Than join, except that it uses the Greater Than Or Equal join:

    SELECT SalesRep.'Last Name',
        SalesRep.'Salary',
        Manager.'Last Name',
        Manager.'Salary'
    FROM 'SalesRep' SalesRep,
        'Manager' Manager
    WHERE SalesRep.'Salary' >=
        Manager.'Salary'

This statement might produce data such as this:

SalesRep Table | SalesRep Table | Manager Table | Manager Table
--- | --- | --- | ---
Last Name | Salary | Last Name | Salary
Davolio | $35,000.00 | Fuller | $32,000.00
Davolio | $35,000.00 | Brid | $30,000.00
Davolio | $35,000.00 | Buchanan | $29,500.00
Davolio | $35,000.00 | Martin | $35,000.00
Dodsworth | $48,300.00 | Hellstern | $45,000.00
Dodsworth | $48,300.00 | Fuller | $32,000.00
Dodsworth | $48,300.00 | Brid | $30,000.00
Dodsworth | $48,300.00 | Buchanan | $29,500.00
Dodsworth | $48,300.00 | Martin | $35,000.00
Patterson | $30,000.00 | Brid | $30,000.00
Patterson | $30,000.00 | Buchanan | $29,500.00

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