Queries and Relationships
|Top Tutorials||New Tutorials||Submit||Login||Register|
Total Hits: 12432
Total Votes: 139 votes
Category: MS Access/Building Databases
Submitted on: 2008-04-15 06:13:30
Submitted By: Shekhar
Description:When creating relationships among tables, we were selecting the primary key of one table and the foreign key of a dependent table to join them. Once such a relationship is created, you can create a query that combines both tables to create a set of records, also called a record set, or a Recordset, that would include either all records or isolate only the records that have entries.
Suppose you want to create a query that includes the persons of this table and their gender. A question that comes is mind: Do you want to create a list of only people who can be recognized by their gender, or do you want the list to include everybody? This concept leads to what are referred to as inner joins and outer joins of queries. There are two ways you can get such queries: you can prepare the relationship between two tables to be aware of this type of relationship or you can directly create it when designing a query. More detail...