I have a view that transforms some records from an older table. Here's a snippet of it:
It seems that when I have two identical records in tablename (which is a legitimate duplicate, the exact same test was done twice on the same subject), only one of those shows up in tablename_vw.
I thought that avoiding the group by would allow duplicates, but have I missed something? How to I keep the duplicate records in my view, similar to the source table?
That did it.
Dieter, I've leveraged many of your answers to others in the past, and really appreciate your help, both here and all the other places. Thank you.