Please help append query giving duplicate records

[rmayur]

I have one append query below :



NSERT INTO FCM ( [Transaction Date], [Order ID], [Intel BusinessID], [Business Name], [Reward ID], [Reward Description], [Redemption Partner], [Unit Point Cost], [Redemption Quantity], [Points Redeemed on Reward], [Principa Contact Login], [Principa Contact Email Address], [Principal Contact Number], [Contact First Name], [Contact Last Name], Country )
SELECT Redemption_report.Transaction_date, Redemption_report.order_ID, Redemption_report.Intel_Business_ID, Redemption_report.Business_name, Redemption_report.reward_id, Redemption_report.order_description, Redemption_report.redemption_partner, Redemption_report.unit_point_cost, Redemption_report.redemption_quantity, Redemption_report.points_redeemed_on_reward, Redemption_report.principal_contact_login, Redemption_report.principal_contact_email_address, Redemption_report.principal_contact_number, Redemption_report.contact_first_name, Redemption_report.contact_last_name, Redemption_report.country_name
FROM Redemption_report
WHERE (((Redemption_report.reward_id) In (337434,359679,374235,374473,377303,377305,377318, 377331)) AND ((Redemption_report.redemption_partner)='FCM'));

It is Giving me duplicate records.

Means if I am importing 10 it giving me back 20 counts of record. Each records have duplication

[lfpm062010]

SELECT Redemption_report.Transaction_date, Redemption_report.order_ID, Redemption_report.Intel_Business_ID, Redemption_report.Business_name, Redemption_report.reward_id, Redemption_report.order_description, Redemption_report.redemption_partner, Redemption_report.unit_point_cost, Redemption_report.redemption_quantity, Redemption_report.points_redeemed_on_reward, Redemption_report.principal_contact_login, Redemption_report.principal_contact_email_address, Redemption_report.principal_contact_number, Redemption_report.contact_first_name, Redemption_report.contact_last_name, Redemption_report.country_name
FROM Redemption_report
WHERE (((Redemption_report.reward_id) In (337434,359679,374235,374473,377303,377305,377318, 377331)) AND ((Redemption_report.redemption_partner)='FCM'));

What does this query returns?

If it only returns 10 records as you expected, then you probably already have record in the table that match what you have just put in.

If it it returns 10+ records, then you probably have duplicate records in your "Redemption_report" table.

Good luck.

[rmayur]

Yes what you said is right..... If actual records has to be 10 but it returns 20... I want to remove that duplicate record... but how?
But in redemption report no duplicate records are available.... please help?

[rmayur]

Please any one can help.......when I get export file in excel it gives record duplication

[lfpm062010]

Using "DISTINCT" or "GROUP BY" will remove the duplicates.

1) SELECT DISTINCT ...FIELDNAMES FROM TABLENAME WHERE .....
2) SELECT FIELD1, FIELD2, ... FIELDN FROM TABLENAME WHERE .... GROUP BY FIELD1, FIELD2, ... FIELDN;