CREATE TABLE projectCategory (
	id_category NOT NULL,
	nama_category VARCHAR ( 150 ) NOT NULL,
    PRIMARY KEY (id_category)
);

INSERT INTO projectCategory(nama_category)
VALUES ('Website');
INSERT INTO projectCategory(nama_category)
VALUES ('Android');
INSERT INTO projectCategory(nama_category)
VALUES ('Internet Marketing');
INSERT INTO projectCategory(nama_category)
VALUES ('Redesign');
INSERT INTO projectCategory(nama_category)
VALUES ('Iklan');
INSERT INTO projectCategory(nama_category)
VALUES ('IOS');

SELECT pro.id_project, pro.nama_project, cat.nama_category
FROM project pro JOIN projectCategory cat ON pro.id_project=cat.id_category