Community discussion forum

problem with select within select

• • Reply

  1 year ago

  by ansari.wajid

  ansari.wajid

  , India

  Joined 2 years ago

   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

  Report abuse
• • Reply

  1 year ago

  by khari6579

  Hari K

  Chennai, India

  Joined 4 years ago

  Hi Ansari

    I have identified the problem in your querey. Actually its basic problem.

  In the WHERE clause your not mentioned any field to validate

  As per you query you can only use in the WHERE clause vRefTable [Because you are selecting vRefTable filed only in the subquerey]

  WHERE vRefTable= or IN or NOT IN or etc...

  I hope you can understand where you have made problem in your querey.

   Good Luck

  Regards

  Hari K...... 

   

  Report abuse