[MySQL] show customers with VAT ID

[franekfrk]

Howto show only those customers who have added VAT ID in SQL?

[tuk66]

Try this query in the SQL Manager

SELECT DISTINCT c.*
FROM ps_address a
INNER JOIN ps_customer c ON (a.id_customer = c.id_customer)
WHERE vat_number IS NOT NULL