mysql-union-menggunakan-query-select.sql

#author          : Agung Pambudi
#email           : mail@agungpambudi.com
#version         : 0.2
#
#
#==============================================================================
#                                   _         _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
#| .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
#|__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
#    |___|       |___|_|


SELECT * FROM barang_20210801 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210802 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210803 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210804 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210805 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210806 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210807 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210808 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210809 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210810 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210811 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210812 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210813 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210814 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210815 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210816 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210817 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210818 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210819 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210820 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210821 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210822 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210823 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210824 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210825 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210826 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210827 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210828 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210829 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210830 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%') UNION
SELECT * FROM barang_20210831 WHERE JENIS='B' AND (CATATAN LIKE '%BPK-Z-%' OR CATATAN LIKE '%BPK-Q-%' OR CATATAN LIKE '%BPK-P-%');