For example, suppose you have a list of employee IDs that appear in your query results. You may have cases in which a query that is based on one table gives you the information you need, but pulling data from another table would help to make the query results even clearer and more useful. View all the records from two similar tables
Use data from a related table to enhance the information in your queryĬonnect the data in two tables by using their relationships with a third table This topic explores some scenarios where you pull data from more than one table, and demonstrates how you do it. But what if, as is more often the case, the data you need is spread out in more than one table? Fortunately, you can build a query that combines information from multiple sources. Sometimes, the process of building and using queries in Access is a simple matter of selecting fields from a table, perhaps applying some criteria, and then viewing the results.
0 kommentar(er)
