Can anybody please suggest how to display results in Smart data browser with self join?
You should not need to do anything different to display the results from a self join in a SmartDataBrowser. The join needs to be handled by the SDO.
The SmartDataBrowser is a visual object that is linked to an SDO. You can decide which fields to display and enable. It does not know or care whether those fields come from one or more database tables or what kind of joins or relationships that are used to realize the SDO.