Skip to content

Instantly share code, notes, and snippets.

@febrianrendak

febrianrendak/fuckyou.sql

Created December 14, 2015 09:49
Show Gist options
  • Save febrianrendak/9eb6ec4d8fb5903b0487 to your computer and use it in GitHub Desktop.
Save febrianrendak/9eb6ec4d8fb5903b0487 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fuckyou.sql
SELECT tab_id, (SELECT ns_nama FROM z_nasabah WHERE ns_id=t.`ns_id`) AS ns_nama,
tab_saldo, tab_tgl_pembuatan, tab_cara_bayar FROM z_tabungan t WHERE tabj_id='TB005'
AND (SELECT uk_id FROM z_nasabah WHERE ns_id=t.ns_id)='UK011' AND tab_cara_bayar='potong_gaji' ORDER BY tab_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment