MySQL : How to I, join this table? [closed]

Question

I have table like this, and i want to output the result like output table, can anyone tell me how to do it, in MySQL

Answer 1

Good morning, you can use LEFT JOIN

try it:

SELECT tb_session.SESSION, tb_schedul.ID_CLASS FROM tb_session LEFT JOIN tb_schedul
ON tb_session.ID = tb_schedul.ID_SESSION;