i'm doing a school schedule and i have this:
as you can see i have the times on the first column and that is from table "tempos_letivos".
now i have a "schedule" table where is the hours of class of the courses, but in this table the cod_prof and cod_curso and i want the names...which are in the "profs" table (cod_prof) and the "course" table (cod_curso).
I'm thinking about the INNER JOIN, but i don't know how
can someone help me put the code, please?