#### Less Than Or Equal [<=] join

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

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

This SQL statement produces data similar to the following:

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

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