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 inline variable assignment?

1002

What are the requirements on sql server network connections?

948

How to modify existing triggers using "alter trigger"?

990

What is indexed view? How to create it?

969

Benefits of Stored Procedures?

956

Where is my database stored on the hard disk in ms sql server?

1040

Describe how to use linked server?

993

What is log in sql server?

1125

What are the fixed server level roles? : sql server security

1105

What is a linked server in sql server?

1053

Determine when to use stored procedure to complete sql server tasks?

1035

How do triggers work?

918

Â Explain what is sql override for a source taLle in a mapping?

988

What Are the Main Features of SQL Azure?

115

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1188