1. UNION berguna untuk menampilkan hasil gabungan dari 2 tabel
SELECT column_name (s) FROM table_name1
-
UNION
SELECT column_name (s) FROM table_name2;
- SELECT column_name (s) FROM table_name1
WHERE column_name (s) IN
(SELECT column_name (s) FROM table_name2);
- SELECT column_name (s) FROM table_name1
WHERE column_name (s) NOT IN
(SELECT column_name (s) FROM table_name2);
Tidak ada komentar:
Posting Komentar