package com.fgkj.db;
|
|
public class DaoView {
|
//在db_alarm数据库下创建view_baoji（包机组）的视图
|
public static String db_alarm_view_baoji="CREATE OR REPLACE VIEW db_equip_user.view_baoji AS "
|
+ " SELECT DISTINCT "
|
+ " db_equip_user.tb_user_battgroup_baojigroup_usr.uId,"
|
+ " db_equip_user.test.tb_user_battgroup_baojigroup_battgroup.BattGroupId,"
|
+ " db_equip_user.tb_user_battgroup_baojigroup_battgroup.StationId "
|
+ " FROM "
|
+ " db_equip_user.tb_user_battgroup_baojigroup_usr, db_equip_user.tb_user_battgroup_baojigroup_battgroup "
|
+ " where db_equip_user.tb_user_battgroup_baojigroup_usr.baoji_group_id= db_equip_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id "
|
+ " ORDER BY db_equip_user.tb_user_battgroup_baojigroup_usr.uId ";
|
}
|
