[dbo].[MANAGEMENT

[dbo].[MANAGEMENT_WBR]

(local) > mdb > Views > dbo.MANAGEMENT_WBR

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:32:02 PM Sunday, December 05, 2010
Last Modified	7:19:28 PM Friday, January 07, 2011

Columns

Name
wbr_stid
wbr_groupid
wbr_node
wbr_type
wbr_timz
wbr_dsc

SQL Script

CREATE view MANAGEMENT_WBR( wbr_stid, wbr_groupid, wbr_node, wbr_type, wbr_timz, wbr_dsc ) as Select s.ID, g.ID, s.CCI_NODE, s.TYPE, s.TIME_ZONE, s.DESCR From ( STATION s left join MANAGEMENT_GROUPS g on s.ID = g.STATIONID)
GO

Uses

[dbo].[management_groups]
[dbo].[station]
dbo