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
10371 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 oltp (online transaction processing)? : Sql dba

1065

Can a commit statement be executed as part of a trigger?

1035

Why do we create views in sql?

1129

What is scope and visibility in PL/SQL?

1179

What is relationship? How many types of relationship are there?

1151

What is the difference between the conventional and direct path loads? : aql loader

1374

Define union, minus, union all, intersect ?

986

what is the stuff function and how does it differ from the replace function? : Sql dba

1031

What is native sql query?

1005

Can function return multiple values in sql?

1030

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1094

Is drop table faster than truncate?

976

What is a data definition language?

1078

What is cross join example?

972

what are aggregate and scalar functions? : Sql dba

1040