Ok I'm working my way through the different type of joins possible with SQL. I can understand all but one, the self join. Can someone please give a nice easy example of why you would want to use a self join.