We need minimum of n-1 joins to join n tables. here 3 tables are there. s

1 SELECT a.field1, b.field2, c.field3, d.field4
2 FROM atable a, atable b, ctable c, dtable d
3 ?
4 ORDER BY 1

What is the minimum number of joins that must be specified
on line 3 in the sample code above to properly link the
tables? Notice that the table "atable" is aliased twice:
once as "a" and once as "b."

1. One join
2. Two joins
3. Three joins
4. Four joins
5. Five joins

Question Posted / sss

6 Answers
10467 Views
Sonata, I also Faced
E-Mail Answers

Answer Posted / sss

We need minimum of n-1 joins to join n tables.
here 3 tables are there.
so we need minimum of 2 joins to join the 3 tables

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is tuple in sql?

1085

What is data type in database?

999

What is the current version of sql?

1024

What is sql exception?

976

What is the difference between microsoft access and sql?

1029

What is difference between hql and native sql?

1177

What is a relationship and what are they?

1154

Can a key be both primary and foreign?

998

What is not equal in sql?

1129

what is a primary key? : Sql dba

1038

Is t sql a programming language?

1070

Is it mandatory for the primary key to be given a value when a new record is inserted?

1198

What are sql data types?

1032

What is the purpose of the sql select top clause?

1116

What is difference between stored function and application function?

1205