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
10199 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 ?

8 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the order of sql select?

989

Is drop table faster than truncate?

942

Difference between global and parameter variables?

1908

What are sql queries used for?

982

What are string functions in sql?

1174

Can we call stored procedure in function?

905

What is the difference between sum and count in sql?

938

What are sql*plus environment variables?

1032

what is the difference between blob and text? : Sql dba

964

What is an exception in PL/SQL? What are the two types of exceptions?

1194

what is data manipulation language? : Sql dba

949

What is pessimistic concurrency control? : Transact sql

1025

tell me about various levels of constraint. : Sql dba

991

What is anonymous block in sql?

1076

What is difference between db2 and sql?

940