Free Preparation Discussions
MENU
SAP Exam C_ABAPD_2309 Topic 1 Question 11 Discussion
Topic #: 1
Given the following Core Data Service View Entity Data Definition:
1 @AccessControl.authorizationCheck: #NOT_REQUIRED
2 DEFINE VIEW ENTITY demo_flight_info_join
3 AS SELECT
4 FROM scarr AS a
5 LEFT OUTER JOIN scounter AS c
6 LEFT OUTER JOIN sairport AS p
7 ON p.id = c.airport
8 ON a.carrid = c.carrid
9 {
10 a.carrid AS carrier_id,
11 p.id AS airport_id,
12 c.countnum AS counter_number
13 }
In what order will the join statements be executed?
The order in which the join statements will be executed is:
scarr will be joined with scounter first and the result will be joined with sairport.
Therefore, the join statements will be executed as follows:
First, scarr AS a will be joined with scounter AS c using the join condition a.carrid = c.carrid. This means that all the rows from scarr will be included in the result, and only the rows from scounter that have the same value for the carrid field will be included. If there is no matching row from scounter, the countnum field will be filled with an initial value.
Second, the result of the first join will be joined with sairport AS p using the join condition p.id = c.airport. This means that all the rows from the first join will be included in the result, and only the rows from sairport that have the same value for the id field as the airport field from the first join will be included. If there is no matching row from sairport, the id field will be filled with an initial value.
Ronnie
1 years agoRegenia
1 years agoJennifer
1 years agoDerrick
1 years agoNell
12 months agoDierdre
12 months agoKarrie
1 years agoErasmo
1 years agoCandida
1 years agoEmilio
1 years agoHershel
1 years agoBurma
1 years agoElmer
1 years agoBulah
1 years agoSheldon
1 years agoJesusita
1 years agoLetha
1 years agoMirta
1 years agoSheldon
1 years ago