main difference between join and subqurey is that join is used for known

Whatz the main diff between Subquery and a Join

Question Posted / adil khan

Answer Posted / adil khan

main difference between join and subqurey is that join is
used for known condition while subquery is used for unknown
condition.

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Describe an oracle table?

989

Is truncate autocommit in oracle?

1024

What are the set operators union, union all, minus & intersect meant to do?

938

what is insert all statement in sql

6397

How do we display rows from the table without duplicates?

920

How to run the anonymous block again?

1066

What are the different types of trigger and explain its various uses and functions?

1010

How to shutdown your 10g xe server?

1083

How to turn on or off recycle bin for the session?

1037

What is redo log?

1006

Why does for update in oracle 8 cause an ora-01002 error?

934

Explain view?

979

What is the use of file param in imp command?

1117

What are the parameters that we can pass through a stored procedure?

1000

What is the parameter mode that can be passed to a procedure?

981