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
Answer Posted / arata kumar pattanaik
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
Answer
generally if n tables will n-1 joins
here 4 tables 3joins
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What program will open a mdb file?
What are the benefits of pl/sql packages?
How do I edit a trigger in sql developer?
how to check myisam tables for errors? : Sql dba
How do I partition in sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How do sql databases work?
What is basic structure of pl sql?
what are the advantages of mysql in comparison to oracle? : Sql dba
What is the difference between local variables and global variables?
what is log shipping? : Sql dba
How do I upgrade sql?
Does group by remove duplicates?
How do I view a sql trace file?