SQL Server 2000

Topic

New Reply

In the Northwind sample database, the Employees table has a one-to-many connection showing as a loop. In other words, the Employees table is both the “many” and the “one”. What does that mean?

Reply | Quote

Replies

The “Reports To” field links back to the ID field of another employee.in the same table. The manager is the “one” and his/her subordinates are the “many”.

Reply | Quote

In addition to what Hans mentioned, this is generally called recursion.

The table is recursive – meaning that it references itself. This is pretty common when dealing with heirarchal relationships in data or code.

Reply | Quote