while select EmplId from EmplTable group by EmplId join GroupTable where EmplTable.EmplId == GroupTable.EmplId && GroupTable.Group == _group