Please observe the comments on your question.
Here is an ANSI SQL way to achieve what you're looking for:
SELECT MAX(customer.[NAME]) AS [Name]
INNER JOIN account
ON customer.id = account.[customer.id]
GROUP BY customer.id
HAVING COUNT(*) > 1
This joins the customer and account table together on the customer id (note it's bad practice ...