Connecting two tables from SQLite Browser (ListView)

I have two tables in one database :

CREATE TABLE KABUPATEN ( id INTEGER, name kabupaten TEXT, PRIMARY KEY (id) ); and, CREATE TABLE DESTINASI ( id INTEGER, name wisata TEXT, name kabupaten TEXT, wisata TEXT types, foto TEXT, deskripsi TEXT, biaya TEXT, latitude TEXT, longitude TEXT, PRIMARY KEY (id) );

I want in the ListView are nama_kabupaten from the KABUPATEN table, so that when ListView nama_kabupaten clicked, will be display ListView nama_wisata from DESTINASI table, corresponding with nama_kabupaten of KABUPATEN table and DESTINASI table?
I have not found the right solution, hopefully here I found the answer, tutorials, etc.