Wednesday, January 6, 2010

Why A SELF JOIN clause?

A self-join is when a single table is referenced more than it uses a different alias each time it refers to the table.
You can use a self-join in this situation, a self-referencing table means the ID and its parent ID in the same table so let see this example:

[001.png]

No comments: