GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  SQL Server

 Print  |  
Question:  Subqueries vs Joins in SQL

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


February 02, 2008 05:36:10 #1
 subbaraovangalli   Member Since: March 2007    Total Comments: 7 
RE: Subqueries vs Joins in SQL
 
if we want to retrive data from more than one table byusing join conditions then we go to join based on the type type of join condition.
sub query is nested quires there is no need of any join condition
     

 

Back To Question