single-row subquery returns more than one row

[xqiu008]

single-row subquery returns more than one row


select SalesRep.SalesR epNumber, SalesRep.last, SalesRep.First, CreditLimit, Customer.SalesR epNumber
From SalesRep, Customer
Where creditLimit = ( Select creditLimit
From Customer
Where creditLimit = 2000);

[r035198x]

single-row subquery returns more than one row


select SalesRep.SalesR epNumber, SalesRep.last, SalesRep.First, CreditLimit, Customer.SalesR epNumber
From SalesRep, Customer
Where creditLimit = ( Select creditLimit
From Customer
Where creditLimit = 2000);

There are many entries in your table where creditLimit is 2000.
[CODE=oracle]Select creditLimit From Customer Where creditLimit = 2000[/CODE] returned more than one value so your outer select will fail because it is expecting only one value with its = comparator there.
Explain what you want to achive so that we may know which query you want to use.

[Saii]

Is this helpful?

select SalesRep.SalesR epNumber, SalesRep.last, SalesRep.First, CreditLimit, Customer.SalesR epNumber
From SalesRep, Customer
Where creditLimit in ( Select creditLimit
From Customer
Where creditLimit = 2000);