MAQ Software interview question

How self joins are used?