What are the type of joins? When do we use Outer and Self joins?

Question Posted / guest

3 Answers
9090 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the type of joins? When do we use Outer and Self joins?..

Types of joins:
->Inner join
->Outer join->1.Left Outer join
2.Right Outer join
->Cross join
->Equi join
->Natural join
->Self join

Outer join:-When we need all rows from one table and some
rows from the other table

Self join:-When one row in a table correlated with other
rows in the same table

Is This Answer Correct ?

6 Yes

0 No

What are the type of joins? When do we use Outer and Self joins?..

Answer / shivanibehere

For the joins you can go for this link ----
http://www.databasejournal.com/features/oracle/article.php/3
527921

Is This Answer Correct ?

2 Yes

0 No

What are the type of joins? When do we use Outer and Self joins?..

Answer / shivanibehere

http://www.tomjewett.com/dbdesign/dbdesign.php?
page=jointypes.php&imgsize=medium

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL Server Interview Questions

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers

What is the purpose of data source?

0 Answers

How to get the definition of a user defined function back?

0 Answers

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers

What are the transaction properties?

0 Answers

Can a table be moved to different filegroup?

0 Answers

CTE(common table expression)

1 Answers Thomson Reuters,

What is the difference between local and global temporary tables?

0 Answers

What is a Trace frag?Where can we use this?

1 Answers

How to get max 100 values from sql server