Going through the edit script concepts one would definitely face joins as one of the features Qlik script has. This document is not about the types of joins rather focusing on one particular type of join i.e., self - join.
I would take the pretty old example from oracle employees table.
Show the list of employee details along with their manager_id and manager name
Lets take the above structure , please see attached emp file for validation.
For accomplishing the above task all we require is Manager name , for which we have to use self join in database.