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

How to include text values in sql statements?

981

How to change parameter value inside the report?

153

How do you create an execution plan?

883

How to define the name and server for a new dsn?

1005

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2663

What is the data tier application?

169

How does clustered and non clustered index work?

848

Is it safe to delete log files?

867

What is bcp? When does it use?

866

What the difference between UNION and UNIONALL?

984

Do you know hot add cpu in sql server 2008?

895

How to see the event list of an existing trigger using sys.trigger_events?

1022

What is a cube? : sql server analysis services, ssas

943

Write a sql query to get zero records from a table having n number of records?

1127

Explain can SSRS reports Cache results?

149