SELF JOIN is used when you need to join a table with itself, commonly seen in hierarchical data structures.