702 views
0 0 votes

In a natural join, the common attribute occur only once, 

but in join

https://gateoverflow.in/3718/gate2004-it-74

Select * from Student, Department

in this common, attribute we have given m+n

I tried in w3 schools

https://www.w3schools.com/sql/sql_join.asp

SELECT *
FROM Orders, Customers
WHERE City='Berlin' AND OrderID = '10248'

here common attribute is occuring only once, 

PLease guide .

Please log in or register to answer this question.

Position:
Show:

Related questions

0 0 votes
0 0 answers
1.7k
1.7k views
aditi19 asked May 8, 2019
1,664 views
how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause?
0 0 votes
0 0 answers
1.0k
1.0k views
Na462 asked Jul 14, 2018
1,048 views
Consider two relations R(A, B, C) and S(B, D) with R contains 5000 tuples stored in a sequential file sorted on attribute A and S contain 100000 tuples stored in a sequen...
1 1 vote
1 answers 1 answer
2.4k
2.4k views
learner_geek asked Jan 24, 2018
2,403 views
My answer is not matching with any of the option.so what is the correct answer
2 2 votes
1 answers 1 answer
2.2k
2.2k views
iarnav asked Nov 27, 2017
2,201 views
Please kindly explain Natural Join by taking your own handmade example in layman terms. Thank you!