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

When to use inner join and left join?

Question Posted / manjeet singh


When to use inner join and left join?..

Answer / Siddhartha Kumar Prasad

Use INNER JOIN when you want to find matching records between two tables. Use LEFT JOIN when you want to retrieve all records from the left table, including those with no match in the right table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is meant by DML?

5 Answers   HCL,

What are different types of queries in sql?

1 Answers  

Can we insert in sql function?

1 Answers  

How do you declare a variable in pl sql?

1 Answers  

What are the types of operators available in sql?

1 Answers  

Why functions are used in sql?

1 Answers  

What is an alias command?

1 Answers  

What are the types of sql commands?

1 Answers  

Can we use commit inside a trigger?

1 Answers  

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

How do I send sql query results to excel?

1 Answers  

Why is there a need for sqlcode and sqlerrm variables?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories