Manhattan Associates interview question

write a Query of Self Join