1
1 SELECT COUNT(1) 2 FROM 3 (SELECT a.id AS "id", 4 a.district AS "district", 5 a.company AS "company", 6 a.type AS "type", 7 a.cargo AS "cargo", 8 a.goods AS "goods", 9 a.weight AS "weight", 10 a.status AS "status", 11 a.remarks AS "remarks", 12 a.create_by AS "createBy.id", 13 a.create_name AS "createBy.name", 14 a.create_date AS "createDate", 15 a.update_by AS "updateBy.id", 16 a.update_name AS "updateBy.name", 17 a.update_date AS "updateDate", 18 a.submit_by AS "submitBy", 19 a.submit_name AS "submitName", 20 a.submit_date AS "submitDate", 21 a.censor_by AS "censorBy", 22 a.censor_name AS "censorName", 23 a.censor_date AS "censorDate", 24 a.censor_note AS "censorNote", 25 a.del_flag AS "delFlag", 26 b.vessel AS "bndExportFreight.vessel", 27 b.voyage AS "bndExportFreight.voyage", 28 b.sheet AS "bndExportFreight.sheet", 29 b.wharf AS "bndExportFreight.wharf" , 30 'b.method' AS "bndExportGeneral.method" 31 FROM bnd_export a 32 INNER JOIN bnd_export_freight b 33 ON a.id = b.export 34 WHERE a.del_flag = ? 35 AND a.type = ? 36 ORDER BY a.update_date DESC 37 ) tmp_count
2
ORA-00904: "B"."METHOD": 标识符无效
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
行 29 列 5 出错
