SQL - Server 2008 - Doubling Problem

[Paramu1973]

I have a Query select sup_ref_no,mpr_no from qotemst where sup_ref_no ='103006' Getting O/P like..... sup_ref_no mpr_no 103006 32 103006 32 Good. No problem. Also I have a Query select mpr_no,mpr_date from mprmst where mpr_no ='32' Getting O/P like..... mpr_no mpr_date 32 2009-10-15 00:00:00:000 32 2009-10-15 00:00:00:000 Good No problem. Also I have a Query select sup_ref_no,mpr_no from qotemst where mpr_no ='32' Getting O/P like..... sup_ref_no mpr_no 1551 32 1551 32 103006 32 103006 32 Good No problem. Also I have a Query Select q.sup_ref_no,q.item_code,q.mpr_no,m.mpr_date from qotemst q,mprmst m where q.sup_ref_no='103006' and m.mpr_no=q.mpr_no or Select q.sup_ref_no,q.item_code,m.mpr_no,m.mpr_date from qotemst q,mprmst m where q.sup_ref_no='103006' and m.mpr_no=q.mpr_no Getting O/P like.....sup_ref_no item_code mpr_no mpr_date 103006 SQUAWAS1 32 2009-10-15 00:00:00.000 103006 SQUAWAS2 32 2009-10-15 00:00:00.000 103006 SQUAWAS1 32 2009-10-15 00:00:00.000 103006 SQUAWAS2 32 2009-10-15 00:00:00.000 Doubling Problem, So how to solve it... Any Ideas...Thanks :thumbsup:

[Niladri_Biswas]

Try the queries like this a) select distinct(sup_ref_no),mpr_no from qotemst where sup_ref_no ='103006' b) select distinct(mpr_no),mpr_date from mprmst where mpr_no ='32' c) select distinct(sup_ref_no),mpr_no from qotemst where mpr_no ='32' then try the last Hope it works :)

Niladri Biswas