Query between 2 related tables - duplicated records in the result set for every record in the 2nd table that it matches.

[Panos Stathopoulos]

Hi from Athens,

I have a db with 3 tables:

table customers
cust_id
name

table charges
charge_id
cust_id
date
amount

table payements
payement_id
cust_id
date
amount


The 3 tables are related on cust_id
table charges and payements are joined on cust_id field.

When i do a query to see the charges and the payements of my clients
the record from the first table is duplicated in the result set for every record in the 2nd table that it matches.

I think that is hapen because records in the first table match more than one record from the 2nd table.

Is there any way to replace the duplicated data by "-"?

Thanks for any help