Hi all., can we join 2 tables without relationship…??
i have tbl_a(id, name)(model name=one)
tbl_b(did,name) (model name=two)
when i try to create 1 record in model one ., i should fetch names from tbl_b in dropdown…
but both tables are not related.
Hi all., can we join 2 tables without relationship…??
i have tbl_a(id, name)(model name=one)
tbl_b(did,name) (model name=two)
when i try to create 1 record in model one ., i should fetch names from tbl_b in dropdown…
but both tables are not related.
You don’t need to join them, just call the model->name from tbl_b inside the form of tbl_a.
echo $form->dropDownList($model,'name', CHtml::listData(tbl_b::model()->findAll(), 'name' ));
yii dropdownList
Unless you have other reasons for joining this should do
cheers