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

What do you understand by a view? What does the with check option clause for a view do?

986

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

2727

What is the difference between online clustering and Offline clustering?

2393

How to count groups returned with the group by clause in ms sql server?

1048

What is Sqlpaging in SqlServer 2005 ?

1045

what is database replicaion? : Sql server database administration

1164

Explain an automatic checkpoint

961

What are the dis_advantages of stored procedures, triggers, indexes?

2202

Where cross join is used?

937

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1016

What is thr feature of change data capture?

963

How do we synchronize On-Premise SQL server with SQL Azure?

120

You want to implement the one-to-many relationship while designing tables. How would you do it?

939

When I run the sql server 2000 setup, it just hangs. What do I do?

1065

What are statistics?

985