I created one database like credit card statement. Purchases all in one table. Debited all in another one table.
I am trying to link two tables using with inner join. But its repeating the data depending on purchases record count.
Table1 = Purchases
Table2 = Received
SELECT * FROM Purchases INNER JOIN Received ON Purcheses.pAcount = Received.rAcount
I am using crystal report 9. Now the out put is coming like this (pls chk the attachment)
I dont want to show the red color rows data
Anyone can help me. thank you