Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Inner Join Select All
- SELECT *
- FROM tb_kota
- INNER JOIN tb_provinsi
- ON
- tb_kota.id_provinsi = tb_provinsi.id_provinsi;
- // Inner Join Select Custom Field
- SELECT nama_kota, nama_provinsi
- FROM tb_kota
- INNER JOIN tb_provinsi
- ON
- tb_kota.id_provinsi = tb_provinsi.id_provinsi;
- // Left Join
- SELECT *
- FROM tb_kota
- LEFT JOIN tb_provinsi
- ON
- tb_kota.id_provinsi = tb_provinsi.id_provinsi;
- // Right Join
- SELECT *
- FROM tb_kota
- RIGHT JOIN tb_provinsi
- ON
- tb_kota.id_provinsi = tb_provinsi.id_provinsi;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement