Error message Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
- From: "ernie" <tina.m.brown@xxxxxxxxxxxxxx>
- Date: 10 Jan 2007 11:52:50 -0800
I am new user to SQL and I am trying to create a sub query. I keep
getting the following error
Subquery returned more than 1 value. This is not permitted when the
subquery follows =, !=, <, <= , >, >= or when the subquery is used as
an expression.
My queries work seperately but when I put them together I get the error
SELECT dbo.tblBusinessAreas.RDBMS, dbo.tblBusinessAreas.BusAreaID,
dbo.tblBusinessAreas.AppNam,
dbo.tblBusinessAreas.AppCmts,
dbo.tblBusinessAreas.AppCmts2, dbo.tblBusinessAreas.Descr,
dbo.tblBusinessAreas.DSDRep,
dbo.tblBusinessAreas.DtLastUptd,
dbo.tblBusinessAreas.SrvyComp, dbo.tblBusinessAreas.SrvyCompDt,
dbo.tblBusinessAreas.SrvyOpenItms,
dbo.tblBusinessAreas.SrvyCmts,
(SELECT dbo.tblUserContacts.UsrLNam AS Tech
FROM dbo.tblUserContacts INNER JOIN
dbo.tblBusAreaContacts ON
dbo.tblUserContacts.UserID = dbo.tblBusAreaContacts.UserID INNER JOIN
dbo.tblBusinessAreas ON
dbo.tblBusAreaContacts.NewBusAreaID = dbo.tblBusinessAreas.BusAreaID)
FROM
dbo.tblBusinessAreas
.
- Follow-Ups:
- Prev by Date: Re: Definition: A Catalog vs. a Database?
- Next by Date: Re: Error message Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
- Previous by thread: "Audit Object Derived Permission Event" doesnt work as documented
- Next by thread: Re: Error message Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
- Index(es):
Relevant Pages
|
