$this->alias('a')
    ->field('a.*, b.has_bed, b.has_wardrobe, b.has_desk, b.has_washin_machine,
     b.has_fridge, b.has_tv, b.has_air_conditioning, b.has_heating,
     b.has_water_heaters, b.has_wifi, b.has_gas, b.has_carpart, b.has_lift')
    ->join('aw_house_attr b', 'a.id = b.house_id')
    ->where(['a.id' => $id])
    ->find();

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aiwo.cmf_aw_house_attr' doesn't exist

评论