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

Which table is left in left join?

Question Posted / neha rastogi


Which table is left in left join?..

Answer / Girish Kumar Arya

In a left join, the left table (also known as the 'left outer' or 'outer left') always includes all its rows, even if there are no matching rows in the right table. The right table only includes rows that have a match in the left table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How you will create Toad Function?

1 Answers  

Who is the owner of mysql database?

1 Answers  

Is ms sql traffic encrypted?

1 Answers  

Explain what is a database?

1 Answers  

Can we use joins in subquery?

1 Answers  

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

What is sql integrity?

1 Answers  

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

what is try_catch block in procedure

1 Answers  

How does pl sql work?

1 Answers  

when normalization is required

3 Answers   HCL,

What's the difference between a primary key and a clustered index?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories