How To Use SQL RIGHT JOIN Query With Example In PHP

Posted By Bajarangi soft , Posted On 18-09-2020

RIGHT JOIN returns all records from the right table , and the matched records from the left table . if there is no match returns NULL from left table.

Syntax for SQL RIGHT JOIN

SELECT column_name list
FROM table1
RIGHT JOIN table2 ON table1.column_name=table2.column_name;

or:

SELECT column_name list
FROM table1
RIGHT OUTER JOIN table2 ON table1.column_name=table2.column_name;

Lets Learn.
1.Create database and two tables
Student table.(left table)

StudentID	StudentName	Address	Section	Branch	Percentage	CourseID
1	Liam	23 Andrew road	A	CSE	66	5
2	Andrew	2415 Anthony market str	A	ISE	80	5
5	Charles	878 Eli Berguvsvägen 8	C	ECE	52	9
9	Andrew	2415 Anthony market str	A	CE	80	2
10	Bhavya	18 Christopher sq.	B	CE	67	9
12	Rajesh	878 Eli Berguvsvägen 8	C	CL	52	3
13	Daniel	878 Eli Berguvsvägen 8	ME	CSE	52	8
15	Connor	878 Eli Berguvsvägen 8	C	ME	52	1
16	Kiran	878 Eli Berguvsvägen 8	ME	ECE	52	10

Course table.(right table)

CourseID	CourseName	CourseCode
1	Mechanical	ME20
2	Chemical	C20
3	Civil	CL20
4	Electrical	E20
5	Computer	CS20
6	Information	IS20
7	Electrical Electronics	EE20
8	Electrical Communication	ECE20

Now we do SQL RIGHT JOIN for both the table.

Example(1)

SELECT course.CourseID, student.StudentName, student.Branch
FROM course
RIGHT JOIN student ON course.CourseID = student.CourseID
ORDER BY course.CourseID

selecting courseid from right table and studentname from left table and branch from table course on RIGHT JOIN of student table by right course table courseid and left student table courseid(course.CourseID = student.CourseID) on order by courseid.

2.Complete code of SQL RIGHT JOIN in PHP script.

<!DOCTYPE html>
<html lang="en">
<head>
    <title> SQL RIGHT JOIN</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
</head>
<body>
<div class="container">
    <div class="text-center">
        <h1> SQL RIGHT JOIN</h1>
    </div>
    <div class="well">
        <?php
        $connect = mysqli_connect("localhost", "root", "", "school_management");

        if ($connect->connect_error) {
            die("Connection failed: " . $connect->connect_error);
        }

        $sql_1 = "SELECT course.CourseID, student.StudentName, student.Branch
                  FROM course
                  RIGHT JOIN student ON course.CourseID = student.CourseID
                  ORDER BY course.CourseID";

        echo "<h2 class='text-danger'> SQL RIGHT JOIN</h2>";
        if($result_1 = mysqli_query($connect, $sql_1)){
            if(mysqli_num_rows($result_1) > 0){
                echo "<table class='table'>
                    <tr>
                     <th>CourseID</th>
                     <th>StudentName</th>
                    <th>Branch</th>
                    </tr>
                    ";
                while($row = $result_1->fetch_assoc()){
                    echo "<tr>
                   <td>".$row['CourseID'] /*student table*/ ."</td>      
                   <td>".$row['StudentName'] /*student table*/ ."</td>      
                   <td>".$row['Branch'] /*student table*/ ."</td>      
                  </tr>";
                }
                echo "</table>";
            } else{
                echo "No records found.";
            }
        }
        ?>
    </div>
    <br>
</div>
</body>
</html>

Related Post

How To Use SQL INNER JOIN Query With Example In PHP
How To Use SQL LEFT JOIN Query With Example In PHP
How To Use SQL RIGHT JOIN Query With Example In PHP
How To Use Left Join Clause With Example Using Laravel
How To Use Right Join Clause With Example Using Laravel
How To Use Cross Join Clause Statement Using Laravel
How To Join Sub Queries With Example Using Laravel
How Can I Use Array Join Method In JavaScript With Example
How to Create a String by Joining the Array Elements using PHP