1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Is left join same as inner join?

Question Posted / saurabh saraswat


Is left join same as inner join?..

Answer / Raju Kumar Roy

No, Left Join and Inner Join are not the same. While an Inner Join only returns records that have matching values in both tables, a Left Join returns all records from the left table (even if there is no match in the right table), along with the matching values from the right table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How to execute OS(operating system) command from pl/sql?

3 Answers  

Why use stored procedures?

1 Answers  

discuss about myisam key cache. : Sql dba

1 Answers  

What is sql partition function?

1 Answers  

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1 Answers  

What is sql table?

1 Answers  

What is sql performance tuning?

1 Answers  

Is null operator in sql?

1 Answers  

Why do we need cursors in pl sql?

1 Answers  

how to get a list of indexes of an existing table? : Sql dba

1 Answers  

Explain the order of sql statement execution?

1 Answers  

What does a pl/sql package consist of?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories