Register

Natural join

362 views
0 votes
0 votes
How is natural join on table with itself is done..can someone help with diffrnt examples
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
aditi19 asked May 8, 2019
814 views
Natural Join Self Doubt
how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause?
how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause?
User Avatar
1 votes
1 votes
0 answers
2
singh chetan asked Jan 28, 2019
828 views
MadeEasy CBT Test 2019: Databases - Natural Join
User Avatar
0 votes
0 votes
1 answer
3
Shamim Ahmed asked Jan 8, 2019
762 views
Natural Join
Suppose we have 2 tables R1(ABCD), R2(DE) . R1 has 500 entries whereas R2 has 1500 entries. Here D is a candidate key. If we join them using natural join. How many entires would be there in the resultant table and why ? Examples would be appreciated..
Suppose we have 2 tables R1(ABCD), R2(DE) . R1 has 500 entries whereas R2 has 1500 entries. Here D is a candidate key. If we join them using natural join. How many entire...
User Avatar
Link Copied!