For the joins you can go for this link ---- http://www.databasejournal.com

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

Question Posted / shivanibehere

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Can I disable or restrict ssrs export formats (rendering formats)?

150

What are different types of replication in sql server?

1084

What are the kinds of subquery?

1008

What is tempdb database? : SQL Server Architecture

1189

What is sql language?

1138

How to enter comments in transact-sql statements?

942

What is the purpose of object explorer and its features? : sql server management studio

1208

What are the character string functions supported by sql server 2005?

1012

wat wil hapn if we give the both read and deny read permission to user?

2103

What are the different types of collation sensitivity in sql server?

1113

How to create new tables with "create table" statements in ms sql server?

1066

Can a unique index be created on a column, which contains null?

917

What is the difference between the 2 operating modes of database mirroring?

1109

Explain the concept of recursive stored procedure.

947

Explain what is the difference between a local and a global temporary table?

995