HERE WE HAVE TOTAL NO. OF TABLE IS 3 SO NO. OF JOIN REQUIRE IS 2

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

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

Answer Posted / satya

HERE WE HAVE TOTAL NO. OF TABLE IS 3 SO NO. OF JOIN REQUIRE
IS 2

Thanks
satya
+919916174212

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is not null in sql?

1109

What is difference between sql and oracle?

1192

Is primary key always clustered index?

1066

Is a secondary key the same as a foreign key?

1120

What is the usage of nvl function?

1103

What are all different types of collation sensitivity?

1077

What is schema in sql example?

1282

Is sql dba a good career? : SQL DBA

1049

What is sql lookup?

973

What is difference between pls_integer and integer?

1011

Explain how can you save or place your msg in a table?

1078

what are local and global variables and their differences? : Sql dba

1139

Can we insert data into view?

950

What are pl sql data types?

1056

What does varchar include?

995