Database - Advanced SQL - Discussion
Discussion Forum : Advanced SQL - General Questions (Q.No. 6)
6.
Which of the following is one of the basic approaches for joining tables?
Discussion:
6 comments Page 1 of 1.
Mark Hornby said:
1 decade ago
The question asks for ONE of the basic approaches for joining, I think the correct answer is Natural Join, subqueries can have performance problems and union joins are not that common they are used to join up multiple results of the same kind.
Sairaj said:
7 years ago
I think the answer is natural join. Because unions combine the set of rows or multiple results from participating tables. Natural join joins the table and then gives the result.
Preeti said:
1 decade ago
Seems option D is fine as the question speaks about the basic approach of joining irrespective of anything.
Tshepang said:
1 decade ago
I think all the above are true and their are responsible for joining tables.
Vaibhav said:
9 years ago
Never heard about Union Join. @Tshepang & @Preeti can you explain?
Ahmed Hakem said:
1 decade ago
How subquery make join?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers