if ($station_mobile) {
$station_id = M('rent_service_station') -> where('mobile','eq',$station_mobile) -> field('id')->find();
$map['station_id'] = $station_id['id'];
}
if($plate_number){
$number = M('rent_car_ids') ->where('plate_number','like' ,'%'.$plate_number.'%')->column('order_id');
$map['order_id'] = array('in', $number);
}
$orderList = M('rent_order')->alias('o')
->join("__RENT_SERVICE_STATION__ ss ", " o.station_id = ss.id")
->join("__RENT_CAR_IDS__ ids ", " o.order_id = ids.order_id")
->field("o.*,ss.name station_name,ss.mobile station_mobile,ids.plate_number")
->where($map)
->select();

---------------------------------
错误语句:SELECT `o`.*,ss.name station_name,ss.mobile station_mobile,`ids`.`plate_number` FROM `tp_rent_order` `o` INNER JOIN `tp_rent_service_station` `ss` ON `o`.`station_id`=`ss`.`id` INNER JOIN `tp_rent_car_ids` `ids` ON `o`.`order_id`=`ids`.`order_id` WHERE `order_id` IN (:where_order_id_in_0)

------------------------------
原页面传递过来的参数，需要去另外一个表查得参数再到rend_order主表查询并显示，如果单查这个rent_order表就没问题，问题现在还需要去联表查询更多的参数来显示；加入联查后查询条件就显报错