select distinct person_number from per_all_people_f
where person_id in (
select distinct person_id
from HRG_GOALS
where GOAL_TYPE_CODE = 'DEVELOPMENT'
and STATUS_CODE != 'COMPLETED')
where person_id in (
select distinct person_id
from HRG_GOALS
where GOAL_TYPE_CODE = 'DEVELOPMENT'
and STATUS_CODE != 'COMPLETED')
No comments:
Post a Comment