Removing duplicate records with crystal reports.

Question

Hi i have problem related to crystal reports while printing report. I need to print a ledger. It contain total number of payments done and on right side its the total purchase made from specific supplier with in particular period.


if u see the above image then the problem can be clearly seen that the left hand side rows are repeated for every row on right side.
Please help me to solve this problem. This result come by pulling data using Sql Query made by Crystal Report.
So Please help me to solve this problem. Its very urgent. Please tell me if i have to write query using the SQL, This help will be highly appriciated.
I have tried to run the query using phpmyadmin SQL editor, the query i wrote is :---

SELECT

`payments`.`paymentDate`,
`payments`.`Paymode`,
`payments`.`amt`,
`payments`.`voucherType`,
`payments`.`Chqddno`

`purchaseinvoicemast`.`bookInvoiceNo`,
`purchaseinvoicemast`.`todaysdt`,
`purchaseinvoicemast`.`finalAmount`,
`purchaseinvoicemast`.`sellersName`,
`purchaseinvoicemast`.`customerCode`

FROM `payments`, `purchaseinvoicemast`
WHERE ((`purchaseinvoicemast`.`customerCode`='SUP3') AND  ( `payments`.`vendorId`='SUP3' ))

Please help this is very urgent for my software....