The following query returns no duplicates.
Full_Name = (Select Distinct i.D1Name From Individual i Join AccountIndividual ai On ai.IndividualKey=i.IndividualKey Join Loan ln on ln.MemberNumber=ai.MemberNumber AND ln.LoanNumber=ai.AccountNumber Where i.IsAccountOwner=-1)
However, when I introduce it as a subquery, I get the annoying:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression
What would be causing the error since I have no duplicates when I use it as a standalone? Thanks.