Subquery returns only one row and Join return More than one rows

what is the main difference between join and subqurey?

Question Posted / udayselva

Answer Posted / udayselva

Is This Answer Correct ?

0 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2527

What do you mean by dbms? What are its different types?

950

what is the difference between char and varchar data types? : Sql dba

1000

How long it takes to learn pl sql?

948

Explain locks? : Transact sql

951

Are views faster than queries?

917

How to execute a stored procedure?

1031

When should I use nosql database?

944

What are the different types of dbms?

954

How does one use sql*loader to load images, sound clips and documents? : aql loader

1117

Can we use rowid as primary key?

942

What is a database? Explain

1050

What are the commands used in sql?

1013

What does the acronym acid stand for in database management?

983

What is trigger in sql and its types?

989