Tables Joining Without Relationship

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