How do you perform a self-join in MYSQL?

Question

Accepted Answer

Self-join is a technique for combining rows from the same table based on a related column, typically with the help of an alias.

Code Example:

```
SELECT A.column1, A.column2, B.column1, B.column2
FROM table_name AS A
JOIN table_name AS B
    ON A.related_column = B.related_column;
```