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
10184 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 null value?

1079

how to check server status with 'mysqladmin'? : Sql dba

1009

What is an index in sql with example?

917

Which sql statement is used to delete data from a database?

895

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

925

What are procedures used for?

919

What is a data manipulation language?

961

How many subqueries can be nested in a statement?

927

What is pl sql record in oracle?

963

What is embedded sql with example?

984

What is sorting in sql?

889

What is posting?

986

What is foreign key in sql with example?

889

Does sql*plus have a pl/sql engine?

994

How to display Row Number with Records in Oracle SQL Plus?

990