Hello,
While I'm quite comfortable to use SQL up to medium level it's one field that gives me grey hair and poor sleep, self join.
Below is the table and its structure with some data: SQLTable1.png
The second screen shot is the result that I want to achieve after executing the SQL question.
However, I do I get the SQL SELECT statement right?
TIA,
Dennis