1) how many number of tables we can join in join concepts?is there any limitation?i think its not...2) since joins and subqueries are used for same purpose , why we have two things.is there any need

Questions by oranachs   answers by oranachs

Showing Answers 1 - 5 of 5 Answers

latha

  • Aug 21st, 2006
 

There is no limit ...

  Was this answer useful?  Yes

nachs

  • Aug 21st, 2006
 

thanks latha

  Was this answer useful?  Yes

RamaKrishna,TCS,Hyd,9989018508

  • Aug 31st, 2006
 

Hi nachs

        In some times we may nt retrive the data from Joins in such scenario we must depend up on sub-queries like Correlation of tables .. to do so we must use Subqueris only...

Thanks&Regds

Ramki,TCS,Hyd

  Was this answer useful?  Yes

krishnaveni_g

  • Jul 16th, 2008
 


we want to join n table we need n-1 join conditions.  There is no limitation.

Some queries not solved by using the joins we can go for subqueries.  Performance wise joins is better.

  Was this answer useful?  Yes

harshasp

  • Jul 16th, 2008
 

To join ntable we need n-1 join conditions....
And whenever we are not able to retrieve the data using Joins..we use Subqueries...
Writing the conditions to query throught join is difficult but through subquery its easy.and performance wise Joins are good...

  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