Hi, i gave distinct here als repetaing,

Output coming like below

Companyname  QuotationID    seskey   quotation_id   Purchageno   Poamount     upload

   yahoo            yah04011240   12            40                 1                   100           <byte>

   yahoo            yah04011242   12            40                 1                   100           <byte>

But here the difference is only QuotationID. There is first record showing  yah04011240   and for second record  yah04011242 .

I dont why this showing like this.

Actually QuotationID is shortname(yah) from tbl_Partnerhirrege and date(040112) and 40(seskey) from tbl_quotation_master.

Please solve this problem