Hi Experts,
I'm trying to write a query that will return only the record that only have RoleID = 1. Group BY ProjectNum. E.g. the record that should be returned is 18003-101-1 because all other project groupings include records with RoleIDs different from 1.
Last bit of info to consider, all groups will have at least one record, that record will have RoleID = 1
See attachment
I'm trying to write a query that will return only the record that only have RoleID = 1. Group BY ProjectNum. E.g. the record that should be returned is 18003-101-1 because all other project groupings include records with RoleIDs different from 1.
Last bit of info to consider, all groups will have at least one record, that record will have RoleID = 1
See attachment