mybatis @Select 连表查语法

//    final static  String sql = "select" +
//        "    tct.check_close_time as checkCloseTime," +
//        "    tct.memo as note," +
//        "    tct.check_remind_time as checkRemidTime," +
//        "    tct.check_status as checkStatus," +
//        "    tmt.manual_type as manualType," +
//        "    tmt.check_remind_person as checkRemindPerson " +
//        "from td_check_test tct left join td_test tmt on tct.manual_type_pkid = tmt.pkid"+
//         "<where>"+
//    QueryBuilderResult.SEG_QUERY_SQL +
//        "</where>" + QueryBuilderResult.SEG_ORDER_BY_SQL;
//
//    @Select("<script>" +
//        sql+
//        "</script>")
//    Page<TdCheckTaskDto> listByPage(Page page,
//                                    @Param("qto") TdCheckTaskQto qto,
//                                    @Param(Constants.WRAPPER) QueryBuilderResult ew);