I have a flat database of business contacts. Below is some sample
ID, Name, Address, Country
1, John Smith, XXX, US
2, Bob Smith, XXX, UK
3, Sean Smith, XXX, US
4, Jane Smith, XXX, France
I want to create a portal on the left side of the layout which shows
the names of the contacts based on a self-join. On the right side, it
will be the record of the contacts.
How do I create the self-join?