t_projectreportbatch表查询语句 - R_STATEMENT_ID = 46 且 R_PARENT_ID = 441424000000

SELECT j.C_ID, j.C_APPLYNAME, j.C_REPORTPHONE, j.C_CREATAT, j.C_REMARK, j.C_REPORTAT, j.C_STATUS, j.m1, j.m10, j.m11, j.m2, j.m3, j.m4, j.m5, j.m6, j.m7, j.m8, j.m9, j.R_PLACE_ID, j.R_STATEMENT_ID FROM t_projectreportbatch as j LEFT JOIN t_place as p on j.R_PLACE_ID=p.C_ID WHERE j.R_STATEMENT_ID = 46 AND p.R_PARENT_ID = 441424000000