Ireneusz Kordal wrote:The easiest way:
If you want only one row for each person, use a case expression (conforming ANSI SQL-92)
Thank you, the second approach is exactly what I want, not the first approach.
However, I wonder if this approach works well with all database?