USE [ISInfoPool]
GO
/****** Object:  View [dbo].[SFA_Email_v]    Script Date: 10/16/2008 20:06:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[SFA_Email_v]
AS
SELECT     dbo.SSQL00_NEmployee_Email_v.ID_no,dbo.SSQL00_NEmployee_Email_v.E_Mail, dbo.SFA_view_by_sort.SFA_FDName,dbo.SFA_view_by_sort.SFA_ComputerName,dbo.SFA_view_by_sort.SFA_SystemTime
FROM       dbo.SFA_view_by_sort INNER JOIN
           dbo.SSQL00_NEmployee_Email_v ON dbo.SFA_view_by_sort.FDOwner = dbo.SSQL00_NEmployee_Email_v.ID_no