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 . Databases natural-join databases sql + – Learner_jai asked Dec 14, 2018 Learner_jai 419 views answer comment Share Follow See 1 comment See all 1 1 comment reply Shivam Kasat commented Dec 14, 2018 reply Follow Share In natural join the common attributes occurs only once because The two column data are exactly same but in cross product this is not the case the two column may or may not contain exactly same data. 0 votes 0 votes Please log in or register to add a comment.