[dbo].[anomalycommentview]

(local) > mdb > Views > dbo.anomalycommentview

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:20 AM Wednesday, March 07, 2007
Last Modified	11:10:20 AM Wednesday, March 07, 2007

Columns

Name
ruleid
fullname
comment
score
active
id

SQL Script

CREATE VIEW "anomalycommentview" AS
       SELECT "a"."ruleid", "b"."fullname", "c"."comment", "c"."score", "c"."active", "a"."id"
       FROM "anomaly" "a", "secure_person" "b", "anomalychange" "c", "anomalylinkobject" "d", "personalias" "e"
       WHERE a.id = d.anomalyid AND d.objecttable = 'person' AND d.objectid = e.id AND e.personid = b.id AND c.anomalyid = a.id

GO

Uses

[dbo].[anomaly]
[dbo].[anomalychange]
[dbo].[anomalylinkobject]
[dbo].[personalias]
[dbo].[secure_person]
dbo