The Concept of joining a table with it self in called "self join"

What is Self Join?

Question Posted / ramesh

Answer Posted / ramesh

The Concept of joining a table with it self in called "self
join"

Is This Answer Correct ?

15 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain syntax for dropping triggers?

917

How can windows applications connect to sql servers via odbc?

1111

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1023

How to get the definition of a stored procedure back?

966

What is a user-defined function in the sql server and what is its advantage?

1078

Can another user execute your local temporary stored procedures?

970

Difference between report and query parameter. Why do we need different type of parameter?

932

What are the different types of backups avaialabe in sql server 2005?

1003

How do you make a trace?

1000

What is sub query and its properties?

966

can you instantiate a com object by using t-sql? : Sql server database administration

986

Explain the relational database management system (rdbms)?

1075

Describe in brief databases and sql server databases architecture.

990

Can I use sql azure as a backup with log shipping or database mirroring?

156

Do you know what is difference between stored procedure and user defined function?

1082