Let we have two related SQL tables: CREATE TABLE `user` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(255) COLLATE utf8_bin NOT NULL, `email` varchar(255) COLLATE utf8_bin NOT NULL, `password` varchar(255) COLLATE utf8_bin NOT NULL, `firstname` varchar(255) COLLATE utf8_bin NOT NULL, `lastname` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin and CREATE TABLE `employee` ( `userid` int(10) unsigned NOT NULL, … Continue reading Yii: Combining two DB tables into one model