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.