ameed
(Ameed Farabi)
August 17, 2011, 10:08am
1
Hi All!
I have three tables :
Categories[has its own id field]
Sub_categories[has its own id and main_category_id fields]
Items[has its own id and sub_category_id fields]
I need all items on main_category id =1…
My sql query looks like this :
SELECT * FROM items i INNER JOIN sub_categories sc ON sc.id = i.sub_category_id INNER JOIN categories c ON c.id = sc.main_category_id WHERE sc.main_category_id = 1…
now with query builder:
$query= Yii::app()->db->createCommand()
->select()
->from('items i')
->join(‘sub_categories sc’, ‘sc.id = i.sub_category_id’)
How can I implement the 2nd join here?
I’d really appreciate any help!
eirikhm
(Eirikhm)
August 26, 2011, 9:23am
2
Hi All!
I have three tables :
Categories[has its own id field]
Sub_categories[has its own id and main_category_id fields]
Items[has its own id and sub_category_id fields]
I need all items on main_category id =1…
My sql query looks like this :
SELECT * FROM items i INNER JOIN sub_categories sc ON sc.id = i.sub_category_id INNER JOIN categories c ON c.id = sc.main_category_id WHERE sc.main_category_id = 1…
now with query builder:
$query= Yii::app()->db->createCommand()
->select()
->from('items i')
->join(‘sub_categories sc’, ‘sc.id = i.sub_category_id’)
How can I implement the 2nd join here?
I’d really appreciate any help!
Quite simple:
$query= Yii::app()->db->createCommand()
->select()
->from('items i')
->join('sub_categories sc', 'sc.id = i.sub_category_id')
->join('categories c','c.id = sc.main_category_id');