Skip to content

Instantly share code, notes, and snippets.

@defrindr

defrindr/gist:ba03a122e3d6148d77ec4d9b8c6c70e3

Created June 22, 2023 10:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save defrindr/ba03a122e3d6148d77ec4d9b8c6c70e3 to your computer and use it in GitHub Desktop.
Save defrindr/ba03a122e3d6148d77ec4d9b8c6c70e3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT t.nama_tim as Nama_Tim, u.fullname as Nama, d.nama_dosen as Dosen, t.total_anggota as total, u.email as Email, p.politeknik as politeknik
FROM tim as t
INNER JOIN users as u ON t.users_id = u.id
INNER JOIN politeknik as p ON p.id = t.politeknik_id
INNER JOIN dosen_pembimbing as d ON d.id = t.dosen_id
WHERE t.kategori_id = 1 AND status_approved = 2 AND t.users_id =u.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment