I have two tables

1. table 2011_nilai: nama,kode_training,n1,n2,n3,n4
2. table 2011_diklat_materi: kode_diklat,no_urut,judul_diklat
Relation with kode_training=30-03-1 and kode_diklat=30-03.

Example data from 2011_nilai

nama kode_training n1 n2 n3 n4
xx 30-03-01 5 6 6 7
aa 30-03-01 7 7 7 7
Data from 2011_diklat_materi

kode_diklat no_urut Judul_materi
30-03 1 biology
30-03 2 mathematic
30-03 3 Physic
30-03 4 chemistry

I want to perform a MySQL query to return results like this:
nilai Judul_materi
N1 biology
N2 mathematic
N3 Physic
N4 chemistry