简单多表查询

//如果需要进行分页的话,和平时操作一样,没有区别

         $Model=new Model();

        $this->companyList=$Model

            ->table(array(

                        C('DB_PREFIX').'company'=>'company',

                        C('DB_PREFIX').'meet'=>'meet',

                        C('DB_PREFIX').'category'=>'category',

                    )

              )

            ->where('company.meetid=meet.id and company.categoryid=category.id')

            ->field('company.* , meet.title , category.category')

            ->order('company.meetid desc')

            ->select();