Good Afternoon,
I am challenged with writing a script to identify records where the trx_number is null by group. Each group will have the same header_id. I would need the query to identify those groups with a null trx_number. There will be other records with a different header_id that do have a trx_number. The bottom line is that the trx_number must be null for all records that have the same header_id. Appreciative of any assistance that can be provided!