lft outer join syntax code example

Example: left join mysql

SELECT 
    Student_details.*,
    Attendance.*
FROM
    Student_details
LEFT JOIN Attendance ON 
    Student_details.s_id = Attendance.s_id;