When you run a database query to find data in related tables, only records that have matching values on both sides of the relationship are found. Most of the time this result will be adequate, but other times you may want to control which records will be displayed. What kind of query allows you to control the records you see, and how did you use this type of query to help answer the manager's
questions for Jasmine?
What will be an ideal response?
In order to find how many books have been rented and show all the titles, even if there were no contracts associated with them, an outer join query was used. There was one title that had zero rentals that would not have shown up by running a normal query.
Computer Science & Information Technology
You might also like to view...
When malicious code is planted on your computer and alters your browser's ability to find web addresses, it is known as ________
A) pretexting B) polymorphing C) phishing D) pharming
Computer Science & Information Technology
To declare a constant MAX_LENGTH inside a method with value 99.98, you write
a. final MAX_LENGTH = 99.98; b. final float MAX_LENGTH = 99.98; c. double MAX_LENGTH = 99.98; d. final double MAX_LENGTH = 99.98;
Computer Science & Information Technology