SOLVED!!!!

INSERT INTO dbo.Affiliate([FullLegalName], [TypeOfEntity], [LicenseNumber], [StateLicensed],

[Website], [TaxID], [Address1], [Address2], [City], [State], [ZipCode],

[ContactPerson], [EMail],[PhoneNumber], [FaxNumber],[CopyOfLicense],

[LicenseBlockNum], [CopyOfW9], [W9BlockNum], [LoginID], [Password])

SELECTISNULL(ELD.[FullLegalName], EWD.[FullLegalName]),

ISNULL(ELD.[TypeOfEntity], EWD.[TypeOfEntity]),

ISNULL(ELD.[LicenseNumber], EWD.[LicenseNumber]),

ISNULL(ELD.[StateLicensed],EWD.[StateLicensed]),

ISNULL(ELD.[Website], EWD.[Website]),

ISNULL(ELD.[TaxID], EWD.[TaxID]),

ISNULL(ELD.[Address1], EWD.[Address1]),

ISNULL(ELD.[Address2], EWD.[Address2]),

ISNULL(ELD.[City], EWD.[City]),

ISNULL(ELD.[State], EWD.[State]),

ISNULL(ELD.[ZipCode],EWD.[ZipCode]),

ISNULL(ELD.[ContactPerson], EWD.[ContactPerson]),

ISNULL(ELD.[EMail],EWD.[EMail]),

ISNULL(ELD.[PhoneNumber], EWD.[PhoneNumber]),

ISNULL(ELD.[FaxNumber],EWD.[FaxNumber]),

ELD.[CopyOfLicense],

ELD.[LicenseBlockNum],

EWD.[CopyOfW9],

EWD.[W9BlockNum],

ISNULL(ELD.[LoginID], EWD.[LoginID]),

ISNULL(ELD.[Password], EWD.[Password])

FROM [#EncyptedLicenseData] ELD

FULL OUTER JOIN [#EncryptedW9Data] AS EWD ON

ELD.[FullLegalName] = EWD.[FullLegalName]

AND ISNULL(ELD.[LicenseBlockNum], EWD.[W9BlockNum]) = ISNULL(EWD.[W9BlockNum], ELD.[LicenseBlockNum])