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:
Posting Komentar