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

Is sql procedural language?

952

Can we insert in sql function?

1063

What is a join?

1046

What is difference sql and mysql?

966

Is there any restriction on the use of union in embedded sql?

1147

what is union? : Sql dba

1006

what are enums used for in mysql? : Sql dba

1157

What is difference between stored function and application function?

1172

What is difference between inner join and self join?

1068

what is data integrity? : Sql dba

1019

What is output spooling in sql*plus?

1020

What schema means?

876

What is parameter substitution in sql?

1013

What are different types of tables in sql?

978

How exception is different from error?

1002