leading-project/dw/dim/dim_building_info_d.sql

8 lines
190 B
MySQL
Raw Permalink Normal View History

2024-07-21 22:06:45 +08:00
SELECT
BuildID -- 楼栋id
, CommID -- 项目id
, BuildSign
, BuildName -- 楼栋名称
, BuildType -- 楼栋类型
FROM ods_erp_tb_hspr_building_d
where IsDelete = 0