Problem Join Table

[171171]

Hai,
I Have Problem in Select Statment .

Syntax:

SELECT bbm.cnobbm,ts.cnoretur,pay.ckdpay
FROM IcTrBBMHD bbm
INNER JOIN
dbo.aptrreturdt ts ON
ts.id_bbm = bbm.id
INNER JOIN
dbo.aptrpaydt pay ON
pay.id_bbm = bbm.id
order by ts.cnoretur,pay.ckdpay

OUTPUT :

cnobbm cnoretur ckdpay
---------- ------------ ----------
0000000374 0000000005 0000000011
0000000374 0000000005 0000000012
0000000374 0000000006 0000000011
0000000374 0000000006 0000000012

(4 row(s) affected)

I want Output Like This

cnobbm cnoretur ckdpay
---------- ------------ ----------
0000000374 0000000005 0000000011
0000000374 0000000006 0000000012

Please Any Body Help . Please


Thank's

 

[putts]

Would just using a SELECT DISINCT on one of the last 2 fields work for you?

 

[pgtek]

Hi

Select distinct