NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ832798
Record Type: Journal
Publication Date: 2007
Pages: 6
Abstractor: As Provided
Reference Count: 6
ISSN: ISSN-1055-3096
Recursive Joins to Query Data Hierarchies in Microsoft Access
Dadashzadeh, Mohammad
Journal of Information Systems Education, v18 n1 p5-10 2007
Organizational charts (departments, sub-departments, sub-sub-departments, and so on), project work breakdown structures (tasks, subtasks, work packages, etc.), discussion forums (posting, response, response to response, etc.), family trees (parent, child, grandchild, etc.), manufacturing bill-of-material, product classifications, and document folder hierarchies are all examples of hierarchical data. Although relational databases can represent such hierarchical data with ease, relational query languages such as Structured Query Language (SQL) and Query-By-Example (QBE) fail to support users in formulating natural queries involving transitive closure of such hierarchical data (e.g., listing all descendants of an individual in a family tree scenario). This paper presents a simple approach for teaching users how to overcome this shortcoming and formulate the required recursive joins in order to query such data hierarchies in Microsoft Access. (Contains 6 figures.)
Journal of Information Systems Education (JISE). c/o Al Harris, JISE Editor, Department of Computer Information Systems, Walker College of Business, Appalachian State University, Boone, NC 28608. Tel: 828-262-6180; Fax: 828-262-6190; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Evaluative
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A