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

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

Question Posted / shivanibehere

Answer Posted / shivanibehere

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to create “alternate row colour”?

146

What are the tables in sql?

1089

How many levels of sp nesting is possible?

1056

What is the ‘fillfactor’?

971

How to find out the list schema name and table name for the database?

942

What is the difference between DATETIME2 and DATETIME?

1085

what is denormalization? : Sql server database administration

928

How do use Having,Group by,Group function in SQL?

1749

How do I create a partition table in sql server?

1129

What is the primary use of the model database?

1087

Why do you need a sql server?

1115

What is a transact-sql statement?

1067

How do you rename a table in sql server?

1032

What is the difference between mysql and mysqli?

1206

Would you store your query in a ssrs report or a database server? State the reason why?

152