New answers tagged


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 = account.[] GROUP BY 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