hi experts

[Former Member]

hi gurus.

actually <b>for inner join condition , maximum how many tables we can use?</b>

regards .

subhasis

[Former Member]

hi,

there is no limit in no of tables any number of tables can bes used in an inner join condition.

regards,

Navneeth.K

[Former Member]

hi,

there is no limit in no of tables any number of tables can bes used in an inner join condition.

regards,

Navneeth.K

[Former Member]

Hi Subhasis,

It is efficient for two or three tables only .

If it is more than three tables means Preformance points of view it will give the lower performance that why In case for inner join we will use the 'FOR ALL ENTERIES'.

if u use this performance is good. We have to follow the Performance standards.

Rgds,

P.Naganjana Reddy

[Former Member]

Hi subhasis,

In Joins concept,there is no limitation of tables that u can join..

but performance issue you can use 2 or 3 tables only.

why b.coz.. if u joined more 2 or 3 tables , performance will be reduced.

i thnk u get my point.

regards,

Vijay.