I am trying to return a single referance to a each unique master record (FILM_PROD_GUDE .RECNO). Because I am returning fields with different values from related tables (FILM_SUBCAT_RE F.SUBNO), I am returning multiple instances of the master record RECNO. Can I use a GROUP BY function to get what I want or am I looking at this whole thing the wrong way.

Any help would be appreciated.... ............... .

thanks dan...