Why do we use joins, instead subquery has same operation?

laxminarayana

• Oct 16th, 2015

JOINS are used to retriveing data from more then one table.
SUBQUERIES are used to condition depends upon one data retriving from another table at the time we use subqueries.

farhan

• Oct 15th, 2015

JOINs are used where you have a complex and large queries. SubQuery is used where you have a very simple scenario and your query is not too lengthy.

Answer Question  Select Best Answer