what is the differences using select statement in a FROM or WHERE clause

• cesimcesisi

  SSC Rookie

  Points: 26

  More actions

  July 24, 2008 at 5:35 am

  #210424

  Hi there,

  I am new on SQL. Ive been working on basic select statment. Now I just came up a complex query that ı dont understand. we can do a subguery in a FROM clause and where clause. what is the mean differences between them? Is the result same or not? How do they work?

  If you have any idea please let me know. I am getting lost in all those.

  thanks in advance

• Grant Fritchey

  SSC Guru

  Points: 399332

  More actions

  July 24, 2008 at 7:41 am

  #847744

  Please don't cross-post.

  Answering over here: http://www.sqlservercentral.com/Forums/Topic540018-149-1.aspx

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning