There should be Three joins in where clause. no point of that the table &qu

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

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

Answer Posted / mohan

There should be Three joins in where clause. no point of that the table "atable" is aliased twice. It will treat as two separate tables....

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can %notfound return null after a fetch?

1040

what are the nonstandard string types? : Sql dba

1124

what are all different types of collation sensitivity? : Sql dba

972

What are the advantages of sql? Explain

1084

What is sql engine in oracle?

974

How can we avoid duplicating records in a query?

963

What is the sql case statement?

980

What is the usage of the distinct keyword?

1202

How many types of triggers exist in pl/sql?

1053

What is difference sql and mysql?

966

How can check sql version from command line?

1065

What is varchar sql?

1120

Sql technical questions

1256

What is column?

976

What is a column in a table?

1109