LATIHAN FLUTTER WEEK#5 : SIKAR MEMBUAT INDEX DAN VIEW MYSQL

LATIHAN FLUTTER WEEK#5 : SIKAR MEMBUAT INDEX DAN VIEW MYSQL

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

Flutter Developer