view : viewKaryawan
CREATE VIEW viewKaryawan AS
SELECT
a.karId,a.karNik,a.karNama,a.karGol,a.karStatus, a.karHp,a.karEmail,a.karAlamat,a.karFoto,
b.userId,b.userName,b.userPass,b.userLevel,b.userStatus,b.userToken
FROM karyawan AS a
INNER JOIN user AS b
ON a.karNik = b.userNik