Difference between joins and subquery?

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

Questions by Ratan satish

Showing Answers 1 - 6 of 6 Answers


  • May 17th, 2015

subquery can be used for simple logical queries , to get
required output/condition
but if you want to compare two or more tables and get output
in the way you want it would be lot difficult to manage all
those with subqueries - so we can use the concept of joins

  Was this answer useful?  Yes

kushal lohakare

  • Aug 5th, 2015

JOIN - Join is a query, which retrieves columns or rows of multiple table.
SUBQUERY - Subquery is a query, whose return values are used in filtering condition of main query.

  Was this answer useful?  Yes


  • 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.

  Was this answer useful?  Yes


  • 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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions