[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	11:10:20 AM Wednesday, March 07, 2007
Last Modified	5:37:24 PM Monday, May 04, 2009

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