SAP 7090310 Datový list stáhnout pdf (Strana 543)

100

101

23.5.10.13 Less Than Or Equal [<=] link

The result set from a Less Than Or Equal link 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 link, except that it uses the Less Than Or Equal link:

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:

SalesRep TableSalesRep TableManager TableManager Table

SalaryLast NameSalaryLast Name

$35,000.00Davolio$32,000.00Fuller

$48,300.00Dodsworth$32,000.00Fuller

$35,000.00Davolio$30,000.00Brid

$48,300.00Dodsworth$30,000.00Brid

$30,000.00Patterson$30,000.00Brid

$35,000.00Davolio$29,500.00Buchanan

$48,300.00Dodsworth$29,500.00Buchanan

$30,000.00Patterson$29,500.00Buchanan

$35,000.00Davolio$35,000.00Martin

$48,300.00Dodsworth$35,000.00Martin

2011-05-16543

Understanding Databases

1 2 ... 538 539 540 541 542 543 544 545 546 547 548 ... 705 706

Komentáře k této Příručce

Vikixwk 04 Jan 2024 | 13:20:14

urenrjrjkvnm

Viktorihon 14 Jan 2024 | 00:44:53

Cinema

SAP 7090310 Datový list Strana 543

Komentáře k této Příručce