Gunakan left join jika ingin semua row tabel paling kiri(paling awal setelah kata from) ditampilkan sedang row dari tabel kedua hanya akan ditampilkan jika memiliki relasi dengan tabel kiri dan sebaliknya.
select en_id as nama, en_title as alamat from epis_en NAMA ALAMAT ---------------------- ------ 8 Kring 1 Flexi 9 The Do 11 Editin 2 5 Calo 7 5 Calo 4 Telkom 5 TELKOM 10 What c 14 Using 3 Welcom 12 Editin 6 Flexi 13 rows selected NAMA ALAMAT ---------------------- -------------------------------------------------- 1 admin 1 rows selected select A.nama as "Nama A", A.alamat as "Alamat A", B.nama as "Nama B", B.Alamat as "Alamat B" from (select en_id as nama, en_title as alamat from epis_en) A left join (select user_id as nama, user_nick as alamat from epis_user) B on A.nama=B.nama Nama A Alamat A Nama B Alamat B ---------------------- --------------------------- -------------------------------------------------- 8 Kri 1 Fle 1 admin 9 The 11 Edi 2 5 C 7 5 C 4 Tel 5 TEL 10 Wha 14 Usi 3 Wel 12 Edi 6 Fle 13 rows selected Moga2 yang dimaksud seperti itu. [Non-text portions of this message have been removed]
