SELECT tbl_karyawan.id_karyawan, tbl_karyawan.email
FROM tbl_mentor_data
JOIN tbl_karyawan ON tbl_mentor_data.nomor = tbl_karyawan.id_karyawan
WHERE tbl_mentor_data.nomor IS NOT NULL;
Give me:
Conversion failed when converting the varchar value ‘0001/KMG/03/2024’ to data type int
Please help me to fix this query
I try to join 2 table,
first table is tbl_karyawan will get data nama, id_karyawan, and email
second table is tbl_mentor_data will get all data from this table
2