Need info on implementing self join with employees

[Conor]

I am quite new to Access. I am using Access 2007. I think I am dealing with a "classic" issue - including supervisor employee number on records and having them refer back to the same "Employees" table.

I have searched the forum and found several references to "self join", but I cannot get any hits back with the forum search engine when I enter the search subject as "self join". Maybe it's a grammar error and someone can give me the correct search box syntax.

I've seen a reference to the Northwind sample DB, but what I downloaded from the templates does not include this feature.

I really would just like a pointer to a good explanation of how self join is implemented - a previous post, a website, a book, anything. I can do the research, and would prefer to. It would help to narrow the potential sources for the answer.

I know literally hundreds of you forum users can supply a reference. Thanks in advance for your suggestions.

Conor

 

[dkinley]

See if this does something for you ..

http://www.databasedev.co.uk/self-join_query.html

-dK

 

[Conor]

Thanks. At first glance, that could be exactly what I need. I'll start there check back as needed. I appreciate the help.

Conor