Retrieving data from multiple tables is similar to retrieving data from a single table, but you need to add more tables that you want to retrieve data from. Those table are generally related to each other.
Example1: You want to retrieve BookID and Title from TblBook and PubName from TblPublisher. To do so, follow the figure below:
Example2: You want to show category name, product name, and quantities of products that are sold.
Through this example, you need to create a query by retrieving data from three tables, TblCategory, TblProduct, and TblSaleDetail. Follow the figure below:
Example3: You want to add more information to the example2 by adding EmpName and Invoicedate fields. To solve this task, do as a shown figure below:
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: