New answers tagged

0

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] FROM customer 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 ...


Top 50 recent answers are included