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
10471 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

Where can I learn sql for free?

998

What is the purpose of using pl/sql?

1150

How much does sqlite cost?

1047

What is sql injection owasp?

1070

what are the 'mysql' command line options? : Sql dba

1078

what are aggregate and scalar functions? : Sql dba

1060

How can I make sql query run faster?

1018

What is a temporal data type?

1055

How does sql*loader handles newline characters in a record? : aql loader

1051

what are the advantages of mysql in comparison to oracle? : Sql dba

1007

How do I view a sql trace file?

1036

What is difference between pl and sql?

1068

What is the difference between microsoft sql and mysql?

967

What is a schema sql?

1161

What is group by in sql?

1089