TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Munwar Zardari
NA
22
0
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]
Reply
Answers (
4
)
Screen Recorder in c#.net
how to retrieve emails from gmail using outlook service in asp.net