What is the difference between Subqueries and Joins? Which is better and Why? Give an example of each.

Hiren

• Nov 29th, 2011

Its true, I would like to add some more information about it, Subquery take separate temp table and checking condition ………….. Besides join is checks conditions first and then put it into tabl...

abdullah

• Sep 12th, 2011

I am software engineer and iam working on oracle mysql and sql so i have lot of experience on this ,basically joins are using there should be connection two or more than two tables ,joins are always o...

Answer Question  Select Best Answer