Which of the following queries finds the clients of banker xyz and the city they live in ?
The query must select banker xyz, join Client and Customer on their customer_name fields, and then project the customer name and city. The expression containing…
Choose your answer
Which of the following queries finds the clients of banker xyz and the city they live in ?
Answer and explanation
Correct answer A
The query must select banker xyz, join Client and Customer on their customer_name fields, and then project the customer name and city. The expression containing client.customer_name = customer.customer_name includes the required join predicate; the alternatives without it leave unrelated rows in the Cartesian product.
Practice for these exams
-
Rajasthan Programmer