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