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 .
64.3k questions
77.9k answers
244k comments
80.0k users