How to get the task type value

Hi Everyone,

What is the query to get the task type value.

When I was trying to query the following manner, I end up getting duplicate values, though I know we have defined only one value for the task type;

******
SELECT distinct p.segment1, p.PROJECT_ID, pt.TASK_NAME, pt.TASK_NUMBER, ptt.TASK_TYPE
FROM pa_projects_all p, pa_proj_elements ppe,
pa_task_types ptt, pa_tasks pt
WHERE p.SEGMENT1 = Project Number
and p.PROJECT_ID = pt.PROJECT_ID
and p.project_id = ppe.project_id
AND ppe.type_id = ptt.task_type_id
order by task_number