akhyrul

Simbada

Sep 25th, 2011
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.24 KB | None | 0 0
  1. SELECT DISTINCT nim FROM mengambil mn
  2. WHERE NOT EXISTS (
  3.     SELECT null FROM mata_kuliah mk
  4.     WHERE NOT EXISTS (
  5.         SELECT null FROM mengambil
  6.         WHERE kode_mk=mk.kode_mk AND mn.nim=nim
  7.     )
  8. )
  9.  
  10. // baru buat nampilin nim yg ngambil semua makul
Advertisement
Add Comment
Please, Sign In to add comment