Database Query

Question

Hi, i have generated a query of database, but it returns repeated data, can any body correct it...
Query::
SELECT hi_custom_fields.field_id, hi_custom_fields.field_name, hi_custom_field_data.data_id, hi_custom_field_data.value, hi_custom_field_data.comments,
hi_project_fields.project_type_field_id, hi_project_type.project_type_id, hi_project_type.type_short_desc, hi_projects.project_id,
hi_projects.project_title
FROM hi_custom_fields INNER JOIN
hi_custom_field_data ON hi_custom_fields.field_id = hi_custom_field_data.field_id INNER JOIN
hi_project_fields ON hi_custom_fields.field_id = hi_project_fields.field_id INNER JOIN
hi_project_type ON hi_project_fields.project_type_id <> hi_project_type.project_type_id INNER JOIN
hi_projects ON hi_project_type.project_type_id = hi_projects.project_type_id
 
Regards:
Munwar
[email protected]