Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
155 Points
421 Posts
Apr 23, 2012 01:15 PM|LINK
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
vsp.santu
Member
155 Points
421 Posts
Re: join sp problem
Apr 23, 2012 01:15 PM|LINK
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