$list=$card->table(C('DB_PREFIX')."card as b")
->join(C('DB_PREFIX')."good as a ON a.id=b.goodid")
->field('b.*,a.goodname,a.goodprice')
->limit($Page->firstRow.','.$Page->listRows)
->order('id desc')
->where($where)
->select(); 最佳答案
