Discuss the advantage of creating a multitable query.
What will be an ideal response?
Multitable queries contain two or more tables and enable you to take advantage of the relationships that have been established in your database. When you extract information from a database with a query, often you will need to pull data from multiple tables. One table may contain the core information that you want, while another table may contain the related data that make the query provide the complete results. The advantage is that data can be stored in separate tables but pulled together to create meaningful information.
You might also like to view...
It is always a good practice to test each formula you enter for accuracy
Indicate whether the statement is true or false
For the applications discussed what placement strategies are employed in implementing the associated services?.
What will be an ideal response?