The following query is used to fill a cursor. I only want one row in the cursor for each PlmName
I need the fields to process data within the cursor.
How do I load the cursor with one row of data related to PlmName?
It seems to me that the simplest way is to just take the email out of the select distinct clause. That should give you 1 row per name. Then to get the email, you can do a sub-select.
answered Sep 19, 2012 at 07:32 PM