Alternatives to self join

[Buntu Dev]

I'm currently doing a self-join on a table 4 times on varying conditions.
Although it works fine, I'm not sure if there are any alternatives that
perform better. Please let me know.

Thanks!