选择a.*,c.category_name FROM products a JOIN product_categories b ON a.id=b.product_id在b.category_id=c.id上加入类别c,其中a.store_id=20
你可以试试这个:
$data = Yii::app()->db->createCommand('Your query here')->queryAll();
var_dump($data);
选择a.*,c.category_name FROM products a JOIN product_categories b ON a.id=b.product_id在b.category_id=c.id上加入类别c,其中a.store_id=20
你可以试试这个:
$data = Yii::app()->db->createCommand('Your query here')->queryAll();
var_dump($data);