Hi
I want to execute below query in ms-sql server 2000 but its giving errors.
Can anybody help please.
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.
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
Loading
Vijaya KadiyalaPosted Sep 30, 2008, 4:11 PM
HI
Why can't you use EXISTS in your WHERE clasue. Tell us your requirement in order to serve better.
Thanks -- Vj
Blocked AccountPosted Sep 25, 2008, 7:51 AM
Hi Wazid,
Send the script of your tables.
then it would be easy to solve your problem.