Inner join outer join--left outer join ,right outer join , full outer jo

explain different types of jions with examples briefly?

Question Posted / hari

Answer Posted / hari

Inner join
outer join--left outer join ,right outer join , full outer
join
Cross Join

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between aggregate and analytic function?

930

Which table keeps information about stored procedures?

938

What is the default value of an integer data type in sql server 2005?

950

explain the storage models of olap? : Sql server database administration

957

Difference between aggregate functions of sql?

1101

What are the advantages of partitioning?

1124

Describe triggers features and limitations?

989

how to take backup bcp out for a column in table in sql server?

2105

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

944

Describe and explain about SQL native client?

1108

what is blocking? : Sql server database administration

1040

What is the difference between indexing and hashing?

1169

What is the command to change the recovery model?

1046

What are constraints in microsoft sql server?

1128

How can I add Reporting Services reports to my application?

129