LEFT and RIGHT JOIN multiple table, show all null data on mariadb 10.3
SELECT r.id, s.name student_name, c.name criteria_name, c.weight
FROM tbl_reporting r
JOIN tbl_student s ON r.id_student = s.id
JOIN tbl_criteria c ON r.id_criteria = c.id
UNION ALL
SELECT NULL, s.name, NULL, 0
FROM tbl_student s
WHERE NOT EXISTS ( SELECT NULL
                   FROM tbl_reporting r
                   WHERE r.id_student = s.id )

UNION ALL
SELECT NULL, NULL, c.name, 0
FROM tbl_criteria c
WHERE NOT EXISTS ( SELECT NULL
                   FROM tbl_reporting r
                   WHERE r.id_criteria = c.id );

https://dbfiddle.uk/?rdbms=mariadb_10.3&amp;fiddle=989338bb30f2f5b4d7be4667763e9522