Left Join and Right Join are SQL JOIN operations used to combine rows from

What is left join and right joins?

Question Posted / Munendra Kumar Tripathi

1 Answers
143 Views
I also Faced
E-Mail Answers

Answer Posted / Munendra Kumar Tripathi

Left Join and Right Join are SQL JOIN operations used to combine rows from two or more tables based on a common column. The difference between the two lies in how they handle null values:n- Left Join: Returns all records from the left table (the one listed first in the JOIN clause) and matching records from the right table.n- Right Join: Returns all records from the right table (the one listed second in the JOIN clause) and matching records from the left table.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Did you contributed the drupal site (any module)?

102

What is the drupal current version?

147

How to create custom table using drupal module?

123

How will you create a field using code?

118