Hi,

I see similar questions posted and I think seem to be to do joins because it’s more powerful. However, sometimes you want ease over power.

Is there any way to display the two records in ONE TABLE:

1. John, Blue & Red dlist]


2. Jane, Red & Green nlist]
   
   as
   
   Blue: John
   
   Red: John, Jane
   
   Green: Jane

WITHOUT JOINS?

Thanks!