419 views
0 votes
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.

Related questions

0 votes
0 votes
0 answers
1
aditi19 asked May 8, 2019
808 views
how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause?
1 votes
1 votes
1 answer
3
learner_geek asked Jan 24, 2018
1,297 views
My answer is not matching with any of the option.so what is the correct answer
2 votes
2 votes
1 answer
4
iarnav asked Nov 27, 2017
1,379 views
Please kindly explain Natural Join by taking your own handmade example in layman terms. Thank you!