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
10196 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 sql injection vulnerability?

872

What is dialect in sql?

890

Does oracle roll back the transaction on an error?

962

how can we destroy the cookie? : Sql dba

961

how can you create an empty table from an existing table? : Sql dba

1080

how do you tune the slow running queries in oracle db , explain the methodology

2072

How do I find sql profiler?

886

How to read/write files from pl/sql?

994

What is trigger explain with example?

985

does sql support programming? : Sql dba

993

Can you selectively load only those records that you need? : aql loader

986

How do I debug a stored procedure?

1042

Can delete statement be rollbacked?

932

Do prepared statements prevent sql injection?

898

How do I view a view in sql?

890