MS SQL

problem with select within select

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Aug 2007

Posts: 33

Reputation: ansari.wajid is an unknown quantity at this point

Solved Threads: 0

ansari.wajid ansari.wajid is offline

Offline

Light Poster

problem with select within select

Sep 24th, 2008

Hi

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

 Help with Code Tags 
 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.

Help with Code Tags

(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

•

Join Date: Aug 2008

Posts: 1,162

Reputation: dickersonka will become famous soon enough

Solved Threads: 138

dickersonka dickersonka is offline

Offline

Veteran Poster

Re: problem with select within select

Sep 24th, 2008

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

 Help with Code Tags 
 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)