Database Query

Mar 10 2010 1:18 AM

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]

Answers (4)