ORDER BY items must appear in the select list if SELECT DISTINCT is specified. select distinct prr.f_amount,pa.f_pro_type, prr.f_mrp,pa.*,re.f_currency as f_currency1,re.f_purchase, (select top 1 f_imagename from t_colorwiseimages where f_productid=pa.f_sno and f_userid=pa.f_userid order by f_order asc,f_imageid asc) as f_imagename, (select top 1 f_classificationid from t_categoryclassification where f_productid=pa.f_sno) as f_classificationid , (select top 1 f_productSequence from t_categoryclassification where f_productid=pa.f_sno) as f_productSequence , (select top 1 f_colorid from t_colorwiseimages where f_productid=pa.f_sno and f_userid=pa.f_userid) as f_colorid from t_productadd pa join t_categoryclassification ccl on ccl.f_productid=pa.f_sno join t_registration re on re.f_sno=pa.f_userid join t_productprice prr on prr.f_productid=pa.f_sno where pa.f_userid=205 and f_pro_type='Buy'and pa.f_status<>0 order by ccl.f_productSequence asc ,f_classificationid desc Rent Exclusive Bridal & Wedding Jewellery in India - Unique Designs in Kundan, Polki, Diamonds, Full Bridal Sets, Rani Haar, Maang Tikka, Hathphools - COD and Doorstep Delivery
  |     |  
Rent Jewels
 +91 99108 13111  | +91 99108 13222

categories

 

OUR COLLECTION

No Records Found. Try using exact search code eg. A2345N
Copyright © 2012, Rentjewels, All right reserved