CREATE VIEW dbo.al_aud_legasstc_view AS select audittable.* from dbo.aud_arg_legasstc audittable WITH(READPAST) left outer join dbo.al_aud_legasstc_potr audpointer on (audittable.lctdid = audpointer.lctdid and audittable.legaldoc_uuid = audpointer.legaldoc_uuid and audittable.own_resource_uuid = audpointer.own_resource_uuid ) where ( audpointer.audit_trail_id is null or  ( audittable.audit_trail_id >= audpointer.audit_trail_id and audpointer.is_deleted != 1 ))
GO