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 ";
}