jangan sombong chuyyyy.... jangan copy paste yaaaa..

Minggu, 24 Juni 2012

UNION, INTERSECT, EXCEPT

UNION


Create database union


Create table cabang_a




Pengisian field  table cabang_a



Table cabang_a


Insert table cabang_a


TABLE cabang_a



CREATE TABLE cabang_b


Pengisian field cabang_b



Table cabang_b


Insert table cabang_b



TABLE cabang_b


SELECT p_nama FROM cabang_a UNION SELECT p_nama FROM cabang_b;
Hasilnya:


SELECT p_nama FROM cabang_a UNION ALL SELECT p_nama FROM cabang_b;




0 komentar: