SELECT 

    C.ACCOUNTNUM, 

    C.PRIMARYCONTACTEMAIL

FROM 

    XLN_CUSTCUSTOMER_VIEW C

WHERE 

    C.DATAAREAID = 'XDB'

    AND C.PRIMARYCONTACTEMAIL NOT IN ('', '-')

    AND C.ACCOUNTNUM IN (...)

---

SELECT

    C.Name AS Namn,

    C.EXU_ADDITIONALNAME AS Adressrad2,

    C.STREET AS Adressrad3,

    '' AS Adressrad4,

    C.ZIPCODE AS Postnummer,

    C.CITY AS Ort,

    C.COUNTRYREGIONISOCODE AS Land,

    'Skellefteå Kraft AB' AS Returadressrad1,            

    'Box 395' AS Returadressrad2,            

    '' AS Returadressrad3,            

    '93124' AS ReturPostnummer,            

    'Skellefteå' AS ReturOrt,            

    'Sverige' AS ReturLand,

    C.EXU_ALTERNATIVECUSTOMERNUMBER AS Personnummer

FROM 

    XLN_CUSTCUSTOMER_VIEW C

WHERE 

    C.DATAAREAID = 'XDB'

    AND (C.PRIMARYCONTACTEMAIL IN ('', '-') OR C.PRIMARYCONTACTEMAIL IS NULL)

    AND C.ACCOUNTNUM IN (...)