Reg. Query Design

• Rajesh Donthu

  Newbie

  Points: 3

  More actions

  September 19, 2007 at 11:01 am

  #178479

  Hi SQL Server Gurus,

  I am trying to design a query, say for example:

  Prod_No, Prod_Desc, Prod_Category_No are 3 columns in the table Products.

  I want to write query in such a way that all

  Prod_NO and Prod_Desc are to be displayed by considering particular prod_Category_No(ex: 001, 303, 244).

  Can any one please let me know how to frame this query.

   

  Thanks in Advance

  Rajesh

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  September 19, 2007 at 1:27 pm

  #734708

  I guess you need something like this:

  Select

  Prod_No,

  Prod_Desc

  from Products

  where Prod_Category_No in (001, 303, 244)