SAP 7090310 Datový list Strana 539

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 706
  • Tabulka s obsahem
  • KNIHY
  • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 538
Orders TableCustomer TableCustomer Table
Order AmountCustomer NameCustomer ID
19164.30BG Mountain Inc.53
1683.60BG Mountain Inc.53
15716.40Hansen MTB Inc.57
1956.20La Bomba de Bicicleta58
24580.50Mountain Toad60
7911.80SFB Inc.62
19766.20Sierra Bicycle Group63
12763.95Sierra Bicycle Group63
8233.50Sierra Mountain64
23.5.10.10 Greater Than [>] link
The result set from a Greater Than link includes all records in which the linked field value from the
primary table is greater than the linked field value in the lookup table. As an example, a company may
want to compare the salaries made by all their sales representatives to the salaries made by all their
sales managers. The company executives want to make sure no sales representative is making more
money than any manager.
With this in mind, you can link the SalesRep table to the Manager table by the Salary field in each table
using a Greater Than link:
SELECT SalesRep.'Last Name',
SalesRep.'Salary',
Manager.'Last Name',
Manager.'Salary'
FROM 'SalesRep' SalesRep,
2011-05-16539
Understanding Databases
Zobrazit stránku 538
1 2 ... 534 535 536 537 538 539 540 541 542 543 544 ... 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