StringBuilder sb = new StringBuilder; sbappend select ; sbappend xC_ID ; sbappend yC_ID as C_IDS ; sbappend yC_STATUS ; sbappend xC_NAME ; sbappend from ; sbappend db_twentyt_place x ; sbappen

String sql = "select x.C_ID, y.C_ID as C_IDS, y.C_STATUS, x.C_NAME from db_twenty.t_place x LEFT JOIN db_twenty.t_projectreportbatch y ON (y.R_STATEMENT_ID = ? AND x.C_ID = y.R_PLACE_ID) WHERE x.R_PARENT_ID = ? AND x.C_DELETED = 0";