This Question Is Answered:
 How To Differentiate Between Equi Join And Natural Join In SQL? Briefly Explain With An Example.
 17 Apr 2007 06:15
 Flag
 For Equi join
Columns need to specify onto which you want to put equi join
For Example
SQL> select dpt.dptno from dept join emp on emp.dptno=dpt.dptno;

Whereas
For natural you need not to specify column names for the join – it will automatically join same name columns in two different tables
For Example
Natural Join:SQL> select dptno from dept natural join emp;
Unrated

0 ratings
by   ssamad
  17 Apr 2007 10:37
 Flag

1000 words left

    


Blurtit Tools:  Email to a Friend    Bookmark this page
What is data independence
in database systems?
Can You Describe CODD'S
RULES For Evaluating A
Relational Database
System?
What Is The Role Of A
Data Administrator?
Can You Write A Program
For Towers Of Hanoi?
What Is Agile Scrum
Methodology?
What Is Unique Index And
Composite Index In Sql?
What is a key? Describe
different types of keys
used in database?
When I select an item in
the drop down list, in
the next page in
dropdownlist the items
What Is Distributive
Database?
What Is Parse VTS
Runtime?
My Blurtit
My Profile
My Questions
My Answers
Blurtit Features
Ask a Question
Answer a Question
Search an Answer
Categories
Tools
Link to Blurtit
Add Blurtit to Firefox
Search Engine
See Your Site Here
Link to Blurtit
RSS
Blurtit.com
About Us
Terms & Conditions
Privacy Policy
Contact Us
Advertise With Us
Help
International
 Chinese Site
 Japanese Site
To continue you need to be registered with us first.

I am already a Blurter, and need to login
I am not a Blurter yet, but would like to register