Hi all
I want use CActiveDataProvider with query below
$sql = "SELECT SD.Ph_ID,SUM(SD.Sales_Quan), P.Ph_Name, P.Price, P.Image
FROM `sales_detail` AS SD, Phones AS P
WHERE SD.Ph_ID = P.Ph_ID
GROUP BY Ph_ID
ORDER BY SUM(Sales_Quan) DESC";
someone help me,thanks.