CTE

Hi Ramya,

 

some time we are unable to join the table based on their data,means when we making join on table we are not able to find appropiate result set, we got repeated data  or not concurrent data so that time we have to need some filter data. o0n based of filter data we make join or else things

basically cte (common table expression) give us ability to join two or more result set (I am telling about result set not table) 

 

see for more details

http://blog.sqlauthority.com/2011/05/10/sql-server-common-table-expression-cte-and-few-observation/