2 2 votes Databases + – Hcas Hgnis 1.3k views answer comment Share Follow Print 0 reply Please log in or register to add a comment.
Best answer 3 3 votes Natural join is a special type of equi join, where the attributes for equality are not specified in the query. Here, the attribute for join is specified in the query. So, (C) should be the answer. http://en.wikipedia.org/wiki/Join_%28SQL%29#Equi-join Arjun answered Dec 3, 2014 • selected Dec 11, 2015 by Akash Kanase Arjun comment Share Follow See all 6 Comments 6 6 Comments reply Show 3 previous comments Arjun commented Dec 3, 2014 reply Follow flag you are welcome :) 0 0 replyShare saket nandan commented Jun 30, 2015 reply Follow flag SIR ACCORDING TO UR WIKIPEDIA its answer should be inner join because in question it is mentioned that we r selecting table1.column & table2.column so only same column produced two times in inner join and in equi join only same column produced only one times sir plzzz clear my doubts 0 0 replyShare focus _GATE commented Jul 17, 2015 reply Follow flag sir, if we have rlation R(A,B,C) ,M(A,V,F,R) than r ⋈ M will give (A,B,C,V,F,R) and ACCording to above query it will give (A,A) only .???? 0 0 replyShare Please log in or register to add a comment.
