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
- 6 Answers
- 8526 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
What is the basic form of sql query?
How many tables can you join in sql?
Why is sql important?
who introduced sql?
What are basic techniques of indexing?
What are the different dml commands in sql?
What are the different types of sql commands?
Which are the different case manipulation functions in sql?
What is dml and ddl?
What are predefined functions in sql?
Is sql difficult?
Why plvtab is considered as the easiest way to access the pl/sql table?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is mutating error in pl sql?
Is sql dba a good career? : SQL DBA
