SELECT columns FROM table1 RIGHT [OUTER] JOIN table2 ON table1.column = table2.column;
SELECT Students.student_id, Students.student_name, Students.student_address, Employee2.salary, Employee2.emp_address FROM Students RIGHT JOIN Employee2 ON Students.student_id = Employee2.emp_id;