1 / 5

Latihan Join-Table

Latihan Join-Table. Jalankan script Join_table.sql (terdapat 2 buah tabel person dan kota) 2. Ketikkan script berikut : SELECT nama,person.kota FROM person INNER JOIN kota ON person.kota=kota.kota Lihat hasilnya, lakukan analisa kenapa demikian ?. OUTER JOIN. LEFT JOIN

abra
Download Presentation

Latihan Join-Table

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Latihan Join-Table Jalankan script Join_table.sql (terdapat 2 buah tabel person dan kota) 2. Ketikkan script berikut : SELECT nama,person.kota FROM person INNER JOIN kota ON person.kota=kota.kota Lihat hasilnya, lakukan analisa kenapa demikian ?

  2. OUTER JOIN • LEFT JOIN SELECT nama,kota.kota FROM person LEFT JOIN kota ON person.kota=kota.kota Lihat hasilnya, lakukan analisa kenapa demikian ? Udin Surabaya Imul Jakarta Dede Jakarta Vina NULL Tutik NULL

  3. OUTER JOIN • RIGHT JOIN SELECT nama,kota.kota FROM person RIGHT JOIN kota ON person.kota=kota.kota Lihat hasilnya, lakukan analisa kenapa demikian ? Imul Jakarta Dede Jakarta Udin Surabaya NULL Solo NULL Yogyakarta NULL Ambon

  4. OUTER JOIN • FULL JOIN SELECT nama,kota.kota FROM person FULL JOIN kota ON person.kota=kota.kota Lihat hasilnya, lakukan analisa kenapa demikian ? Udin Surabaya Imul Jakarta Dede Jakarta Vina NULL Tutik NULL NULL Solo NULL Ambon NULL Yogyakarta

  5. CROSS JOIN SELECT nama,kota.kota FROM person CROSS JOIN kota Order by nama Lihat hasilnya, lakukan analisa kenapa demikian ? Dede Jakarta Dede Surabaya Dede Solo Dede Yogyakarta Dede Ambon Imul Jakarta Imul Surabaya Imul Solo Imul Yogyakarta Imul Ambon Tutik Jakarta Tutik Surabaya Tutik Solo Tutik Yogyakarta Tutik Ambon Udin Jakarta Udin Surabaya Udin Solo Udin Yogyakarta Udin Ambon Vina Jakarta Vina Surabaya Vina Solo Vina Yogyakarta Vina Ambon

More Related