11 lines
278 B
MySQL
11 lines
278 B
MySQL
|
SELECT
|
||
|
|
MeterID -- 仪表id
|
||
|
|
, RoomID -- 房间id
|
||
|
|
, CommID -- 项目id
|
||
|
|
, MeterSign
|
||
|
|
, MeterName -- 表名称
|
||
|
|
, InitAmount -- 初始金额
|
||
|
|
, MeterType -- 仪表类型
|
||
|
|
, StanID -- 标准id
|
||
|
|
FROM ods_erp_tb_hspr_customermeter_d
|
||
|
|
where IsDelete = 0
|