datatpsaceh
datatpsbali
datatpsbangka
datatpsbanten
datatpsbengkulu
datatpsgorontalo
datatpsjabar
datatpsjakarta
datatpsjambi
datatpsjateng
datatpsjatim
datatpsjogja
datatpskalbar
datatpskalsel
datatpskalteng
datatpskaltim
datatpskalut
datatpslampung
datatpsluarnegeri
datatpsmaluku
datatpsmalukuutara
datatpsntb
datatpsntt
datatpspapua
datatpspapuabarat
datatpspapuabaratdaya
datatpspapuapegunungan
datatpspapuaselatan
datatpsriaukepulauan

SELECT d.* 
FROM datadesajabar d
LEFT JOIN datatpsjabar t ON d.kode_dusun = t.kode_dusan
WHERE t.kode_dusun IS NULL;


SELECT *
FROM (
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsaceh
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsbali
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsbangka
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsbanten
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsbengkulu
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsgorontalo
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsjabar
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsjakarta
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsjambi
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsjateng
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsjatim
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsjogja
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpskalbar
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpskalsel
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpskalteng
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpskaltim
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpskalut
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpslampung
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsluarnegeri
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsmaluku
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsmalukuutara
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsntb
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsntt
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpspapua
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpspapuabarat
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpspapuabaratdaya
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpspapuapegunungan
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpspapuaselatan
    UNION ALL
    SELECT *, anis + prabowo + ganjar AS total_suara
    FROM datatpsriaukepulauan
) AS semua_tabel
WHERE total_suara > 300;