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
10195 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

Explain the difference between sql and mysql.

1003

What is sql injection vulnerability?

872

Why indexing is needed?

940

Can we call dml statement in function?

979

What is offset and limit in sql?

1002

Can I join the same table twice?

996

State some properties of relational databases?

1003

what are enums used for in mysql? : Sql dba

1114

What is foreign key in sql with example?

892

How to Execute a Package in PL/SQL.?

1110

What is an inner join sql?

956

How do temporal tables work?

909

What are the key differences between SQL and PL SQL?

1149

What is the use of <> sql?

933

Is full outer join same as cross join?

915