Queries Access Records
The query is the perfect tool to manipulate tables. So far, substantial space has been devoted to topics involving fields and tables. But what about records? With queries, records come to the forefront. A table is a set of records, whereas a record is a set of fields. You might not need to see all the records or fields in a particular table. With a query, you pick and choose which records and fields you want to see.
Queries produce subsets, which are the records that match the query conditions. A table is a set of records; a subset is a set of a set of records. You might not need to see every state in your table. What if you just want to examine the Texas records? Or what if you want to see totals of all the states? Queries ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access