"I doubt" "I don't agree"
What am I lying here!?
I ran the query with and without the group by.

If I omit this section..

"GROUP BY plno.svc_grp_nr,
plno.nvp_ter_nr,
plno.pln_grp_nr,
plno.nvp_nr"

I get no rows, if it is left in I get 20 rows returned.

Never question my limited intelligence and integrity again, shame on both of you!



MH