distinct su 2 campi

[optime]

fantasia!

SELECT DISTINCT indirizzo FROM
(
SELECT Shipping_email AS indirizzo FROM ORDERS 
UNION
SELECT billing_email AS indirizzo FROM ORDERS 
UNION
SELECT shipping_notes AS indirizzo FROM ORDERS 
UNION
SELECT billing_notes AS indirizzo FROM ORDERS 
)