Advertisement
mrboombaw32

Untitled

Apr 3rd, 2024
693
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.95 KB | Source Code | 0 0
  1. select
  2.   d.KDPSTMSMHS as kode_prodi,
  3.   d.SMAWLMSMHS,
  4.   d.STMHSMSMHS as status,
  5.   a.npm,
  6.   d.NMMHSMSMHS as nama,
  7.   a.kelas,
  8.   a.sex as jk,
  9.   a.nisn,
  10.   a.ktp as nik,
  11.   a.agama,
  12.   a.no_kps,
  13.   a.nama_ayah,
  14.   a.nama_ibu,
  15.   a.kewarganegaraan,
  16.   a.alamat as jalan,
  17.   a.rt,
  18.   a.rw,
  19.   a.penerima_kps,
  20.   a.jenis_tinggal,
  21.   a.kebutuhan_khusus_mhs,
  22.   (
  23.     select
  24.       tk.name
  25.     from
  26.       tbl_kelurahans tk
  27.     WHERE
  28.       tk.id = a.kelurahan
  29.   ) as desa,
  30.   (
  31.     SELECT
  32.       tk.id_wil
  33.     FROM
  34.       tbl_kecamatans tk
  35.     WHERE
  36.       tk.id = a.kecamatan
  37.   ) as kec,
  38.   a.kota as kab,
  39.   a.provinsi as prov,
  40.   a.tpt_lahir,
  41.   a.tgl_lahir,
  42.   a.email,
  43.   a.no_hp,
  44.   b.no_ujian,
  45.   a.npwp,
  46.   a.kode_pos
  47. from
  48.   tbl_bio_mhs as a
  49.   join tbl_register as b on a.npm = b.npm
  50.   join tbl_mahasiswa as d on a.npm = d.NIMHSMSMHS
  51. where
  52.   substr(a.npm, 1, 4) = '2023'
  53.   and d.KDPSTMSMHS = '61001'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement