User`s guide

'Manager' Manager
WHERE SalesRep.'Salary' >
Manager.'Salary'
This SQL statement might produce data similar to this:
Manager TableManager TableSalesRep TableSalesRep Table
SalaryLast NameSalaryLast Name
$32,000.00Fuller$35,000.00Davolio
$30,000.00Brid$35,000.00Davolio
$29,500.00Buchanan$35,000.00Davolio
$45,000.00Hellstern$48,300.00Dodsworth
$32,000.00Fuller$48,300.00Dodsworth
$30,000.00Brid$48,300.00Dodsworth
$29,500.00Buchanan$48,300.00Dodsworth
$35,000.00Martin$48,300.00Dodsworth
$29,500.00Buchanan$30,000.00Patterson
In this table, there is no relationship established between sales representatives and sales managers.
Since all managers have seniority over all sales representatives, a company might find it necessary to
check if any representatives make more money than any managers, evidence of a salary problem that
needs to be remedied.
23.5.10.11 Greater Than Or Equal [>=] link
2012-03-14539
Understanding Databases