Table Aliasing mysql> SELECT m.nrp,m.nama, p.kd_mk, p.nilai -> FROM mahasiswa m -> INNER JOIN pengambilan p -> ON m.nrp=p.nrp; +---------+-----------+-------+-------+ | nrp | nama | kd_mk | nilai | +---------+-----------+-------+-------+ | 0471007 | Spiderman | IF004 | 70 | | 0471019 | Superman | IF003 | 90 | | 0471007 | Spiderman | IF002 | 88 | | 0471019 | Superman | IF002 | 88 | | 0471011 | Batman | IF002 | 88 | | 0571022 | Robin | IF002 | 82 | | 0471019 | Superman | IF004 | NULL | +---------+-----------+-------+-------+
{}