2 votes 2 votes Hcas Hgnis asked Dec 3, 2014 Hcas Hgnis 564 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 3 votes 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 See all 6 6 Comments reply Show 3 previous comments Arjun commented Dec 3, 2014 reply Follow Share you are welcome :) 0 votes 0 votes saket nandan commented Jun 30, 2015 reply Follow Share 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 votes 0 votes focus _GATE commented Jul 17, 2015 reply Follow Share 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 votes 0 votes Please log in or register to add a comment.
