X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Closed TopicStart new topic
>  ACCGENERAL Creating and Using Self-Joins    
post Nov 28 2003, 11:49 PM

UA Forum + Wiki Administrator
Posts: 14,057
Joined: 26-September 02
From: Sudbury, Ontario, Canada

Title: ACCGENERAL Creating and Using Self-Joins
Symptom: You have data in a table where one record can be the parent record of other records n the table

Subject: Table Relationships Using Self-Joins

Applies to: Access 97 and later versions Tested in: Access 2000
Skill level:Intermediate
Author: Glenn Lloyd Date: November 28, 2003
Keywords:self-joins, relationships, normalization, aliases

Overview: In certain situations, one member of a table is the parent of other records. In the example, we have two categories of employees, supervisors and employees. Supervisors belong to both categories; that is, they are both supervisors and employees. A one to many relationship exists between supervisors and employees. The self-join, in which a table is joined to itself avoids the need for a second table for supervisors which would lead to data redundancy. The tutorial also introduces the notion of using an alias for a query data source.

The zip file includes a demo database dbselfjoin.mdb in Access 2000 format.
Attached File(s)
Attached File  Self-Joins.zip ( 83.32K )Number of downloads: 1370
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 11:56 AM