What is a Self Data Join in Access 2007? Simply put a Self Data Join is a query where you join, or link a Table back into itself. For example, say you have a table that contains a list of all your employees, including the Supervisor's ID of those employees. And say you want to be able to show the Supervisors Name next to every employee. You'll then want to create a self link or Join to the same table. Of course you'll run into clarification issues as to what to name the columns as they come with their own default names. I mean you wouldn't want to list the employees name for one column and have the next column for the Supervisors called Employees as well.

Purchase the training video and you can see this in action for yourself!