select ID,
(select p.name from sample$projects p where p.id = PROJECT_ID) project,
       (select m.name from sample$project_milestones m where m.id = MILESTONE_ID) milestone,
       NAME,
       DESCRIPTION,
       ASSIGNEE,
       START_DATE,
       END_DATE,
       COST,
       IS_COMPLETE_YN,
       CREATED,
       CREATED_BY,
       UPDATED,
       UPDATED_BY
  from SAMPLE$PROJECT_TASKS