Make this part return no more than one row:

select a."PGroup" from Producer A, TRX b where a."Producer" = b."Producer"