467 views
1 votes
1 votes

What will be the output of Natural Join if there is(are) common attribute(s) in two relations but no common value in these common attribute(s) ?

for example

Table R

A B
6 9
7 1

Table S

B C
7 3
5 8

R Natural Join s will be ? 

1 Answer

Related questions

0 votes
0 votes
0 answers
1
aditi19 asked May 8, 2019
780 views
how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause?
1 votes
1 votes
0 answers
2
0 votes
0 votes
1 answer
3
Shamim Ahmed asked Jan 8, 2019
713 views
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...