SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Mohammad Irfan / SELECT Statement Questions / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 22:15:55 GMT20SELECT Statement Questionshttp://www.sqlservercentral.com/Forums/Topic466076-1214-1.aspxHello All,I am a Newbie to SQL Server, and just finished an extensive online course covering everything from development to optimization.I have found that most of my questions are regarding syntax.In the following SELECT statement, the goal is to select only beverages from Northwind DB:-----------------USE NorthwindSELECT ProductNameFROM ProductsWHERE CategoryID IN(SELECT CategoryIDFROM CategoriesWhere CategoryName = 'Beverages')----------------------I am unclear as to why there is a "sub SELECT" statement after WHERE Category ID IN is. The syntax is confusing to me.Would you please describe in basic terms why this query is built the way it is. Thank you for your assistance.Fri, 07 Mar 2008 12:41:50 GMTrobertafricker