RE: 1) how many number of tables we can join in join c...
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...
RE: 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
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.
RE: 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
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...
