i know this question might be dumb and might be duplicated. but im having a problem with my left join query. so please help Y.Y
the output im currently is something like this
judge name|score judge1 |87 judge2 |87 judge3 |87 judge4 |87
but the output that i want is with null like something like this
judge name|score judge1 |87 judge2 |87 judge3 |87 judge4 |87 judge5 |null judge6 |null
scores are varchar and if table has no record match from table 1 will be automatically should be null or much better for default score of 87.
my query sample
SELECT j.judge_name,s.score FROM `tbl_judges` j LEFT JOIN tbl_scoring s on j.id = s.jud_id where s.crit_id = 1 and s.can_id = 11