First, remove id_kat from supersubkategori table as it is redundant and you can derive it from the subkategori table by id_sub, this concerns
http://www.studytonight.com/dbms/database-normalization.php[
^]
Next, instead of *, Second, specify the output fields explicitly, e.g.
SELECT ss.id_supersub, ss.nama_supersub, k.nama_kat, s.nama_sub FROM supersubkategori ss INNER JOIN subkategori s ON s.id_sub=ss.id_sub
INNER JOIN kategori k on s.id_kat = k.id_kat ORDER BY ss.id_supersub ASC