generally if n tables will n-1 joins here 4 tables 3joins

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 / rao

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

Answer Posted / rao

generally if n tables will n-1 joins
here 4 tables 3joins

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 a primary key sql?

1034

What is trigger in sql? Explain

976

how to drop an existing index in mysql? : Sql dba

1056

What are the different types of joins in sql?

1744

What is the difference between a procedure and a function?

1087

How do I know if I have sql express or standard?

1019

What is sqlite used for?

982

how to start mysql server? : Sql dba

1182

What is pl sql commands?

1026

How to read xml file in oracle pl sql?

899

Is sqlite thread safe?

1034

Which operator is used in query for pattern matching?

1075

What is procedure function?

1044

How many triggers can be applied to a table?

1045

What is sql mysql pl sql oracle?

1059