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

100

101

23.5.10.7 Enforced To

When you select this option, if the from table for the link is used, the link is enforced. For example, if

you create a link from TableA to TableB using Enforce To and select only a field from TableA, the join

to TableB will be enforced, and the Select statement that is generated will include both tables.

Note:

For an explanation of from and to tables, see Link from and link to.

23.5.10.8 Enforced Both

When you select this option, if either the from table or the to table for this link is used, the link is enforced.

23.5.10.9 Equal [=] link

The result set from an Equal link includes all the records where the linked field value in both tables is

an exact match. In the following example, the Customer table is linked to the Orders table by the

Customer ID field. When the program finds a Customer ID in the Orders table that matches a Customer

ID in the Customer table, it displays information for the corresponding records in both tables.

SQL uses the following syntax to describe an Equal link:

SELECT Customer.'Customer ID',

Customer.'Customer Name',

Orders.'Order Amount'

FROM 'Customer' Customer,

'Orders' Orders

WHERE Customer.Customer ID =

Orders.Customer ID

This statement produces the following data:

Orders TableCustomer TableCustomer Table

Order AmountCustomer NameCustomer ID

25141.50Allez Distribution52

2011-05-16538

Understanding Databases

1 2 ... 533 534 535 536 537 538 539 540 541 542 543 ... 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 538

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