CREATE VIEW dbo.vew_VersaDevMSCRMContactDetails
AS
SELECT     dbo.ContactBase.ContactId, dbo.ContactBase.AccountId AS OrganizationID, dbo.ContactBase.Salutation, dbo.ContactBase.JobTitle, 
                      dbo.ContactBase.FirstName, dbo.ContactBase.Department AS OrganizationLevel1, '' AS OrganizationLevel2, '' AS OrganizationLevel3, 
                      '' AS OrganizationLevel4, dbo.ContactBase.NickName AS KnownAs, dbo.ContactBase.MiddleName, dbo.ContactBase.LastName, 
                      dbo.ContactBase.EmployeeId, dbo.ContactBase.WebSiteUrl, dbo.ContactBase.EMailAddress1, dbo.ContactBase.EMailAddress2, 
                      dbo.ContactBase.EMailAddress3, dbo.ContactBase.Telephone1, dbo.ContactBase.Telephone2, dbo.ContactBase.Telephone3, 
                      dbo.ContactBase.Fax AS Fax1, '' AS Fax2, dbo.CustomerAddressBase.Name AS AddressName, dbo.CustomerAddressBase.Line1 AS Address1, 
                      dbo.CustomerAddressBase.Line2 AS Address2, dbo.CustomerAddressBase.Line3 AS Address3, dbo.CustomerAddressBase.City, 
                      dbo.CustomerAddressBase.PostalCode AS Zip, dbo.CustomerAddressBase.Country AS CountryName, 
                      dbo.CustomerAddressBase.StateOrProvince AS StateName, dbo.AccountBase.Name AS OrgName
FROM         dbo.ContactBase LEFT OUTER JOIN
                      dbo.AccountBase ON dbo.ContactBase.AccountId = dbo.AccountBase.AccountId LEFT OUTER JOIN
                      dbo.CustomerAddressBase ON dbo.ContactBase.ContactId = dbo.CustomerAddressBase.ParentId
WHERE     (dbo.CustomerAddressBase.AddressNumber = 1)