DROP TABLE IF EXISTS `tbl_nova`; CREATE TABLE tbl_nova( id INT AUTO_INCREMENT, jmbg VARCHAR(13) NOT NULL, ime VARCHAR(50), zarada INT, PRIMARY KEY (id) ); INSERT INTO tbl_nova ( jmbg, ime, zarada ) SELECT DISTINCT jmbg, ime, zarada FROM tbl_stara