Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10628 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 primary key sql?
what is foreign key? : Sql dba
What is difference sql and mysql?
Explain ddl statements in pl/sql?
Why is nosql good?
Can there be more than one function with a similar name in a pl/sql block?
How do you delete data from a table?
What is a left join?
Is left join faster than inner join?
Explain aggregate functions are available there in sql?
What are the datatypes available in pl/sql ?
Is it possible to sort a column using a column alias?
Can a varchar be a primary key?
how would you enter characters as hex numbers? : Sql dba
how does a local variable is defined using t-sql? : Transact sql
