``` $orders=M("Ordergood")->alias('a')->field('a.shuliang,a.xjiage,a.danwei,a.order_id,b.flow,b.financetime') ->join($px.'order b on b.id=a.order_id and (b.flow=4 or b.flow=5)','left') ->where('gid='.$_REQUEST['gid'])->where($map1)->select(); ```