problem with select within select

Expand Post »

Hi

I want to execute below query in ms-sql server 2000 but its giving errors.
Can anybody help please.

MS SQL Syntax (Toggle Plain Text)
SELECT * FROM ( SELECT vRefTable FROM mainmenu WHERE iMenuId=58 )
WHERE (SELECT vFieldsName FROM TableField WHERE iMenuId=58
AND bIsPrimary=1 AND iTableFieldId=11) = 1
select * from ( select vRefTable from mainmenu where iMenuId=58 )
where (select vFieldsName from TableField where iMenuId=58
and bIsPrimary=1 and iTableFieldId=11) = 1

Its showing below errors. your help is greatly appreciated.

(Toggle Plain Text)

Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'where'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near '='.

Thanks
Ansari

Similar Threads

passing values of Select box from JSP to Action class thru form Bean in JSP
bank system problem !!!! (C++ programming) in C++
problem for a simple asp.net query in ASP
pagination problem in PHP
yupsearch problem - HELP in Viruses, Spyware and other Nasties

ansari.wajid

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

47 posts
since Aug 2007

Permalink

Sep 24th, 2008

Re: problem with select within select

you need to specify what column for the where and the =1 i have no clue what you are wanting there

MS SQL Syntax (Toggle Plain Text)
 
SELECT * FROM ( SELECT vRefTable FROM mainmenu WHERE iMenuId=58 )
WHERE 
-- your column name here
 vFieldsName  IN 
(SELECT vFieldsName FROM TableField WHERE iMenuId=58
AND bIsPrimary=1 AND iTableFieldId=11)
select * from ( select vRefTable from mainmenu where iMenuId=58 )
where 
-- your column name here
 vFieldsName  in 
(select vFieldsName from TableField where iMenuId=58
and bIsPrimary=1 and iTableFieldId=11)

dickersonka

Reputation Points: 133

Solved Threads: 141

Veteran Poster

Offline

1,162 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Matching user preferences

Next Thread in MS SQL Forum Timeline: mssql connection problem with PHP

DaniWeb Message

Cancel Changes

User Name
Password