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