matching values twin tables query (sql coldfusion)

i have query list bottom values list libel values. any value pivotal matches other. bottom values stored list libel values another. problem i need relating bottom values private query solely one. then, i trade query an comparison spreadsheet (i apportionment fine) grant user correct libel values.

when user edits and/or inserts new libel values, i need transform database solely minute over any relating values database (like those private initial time).

in simplicity, fan pays translations i beget square fewer translations indispensable (like phrases reappear often) following save money, hence digest start with. i comprehend downside loyal related list, where relating values go quarrel libel list (which have easy). instead, there churned values relating need updated described above.

---

yeah, i'm confused since competence seem small vague. here's sample:

table 1
item description1
item description2
item description3
item description2
item description2
item description4
item description5
item description6
item description3

table 2
item desc language1
item desc language2
item desc language3  (blank)
item desc language3
item desc language4
item desc language5
*blank*

desired outcome (when queried)

table 1
vigilant description1
vigilant description2
vigilant description3
vigilant description4
vigilant description5
vigilant description6

table 2
item desc language1
item desc language2
item desc language3 (filled relating quarrel list 2)
item desc language4
item desc language5
item desc language6 (blank, returned lifeless string)

the user creates modifications, including inserting information vacant rows (like quarrel 6 language) following reuploads:

table 1
item description1
item description2
item description3
item description2
item description2
item description4
item description5
item description6
item description3

table 2
item desc language1
item desc language2
item desc language3  (now matches quarrel below)
item desc language3
item desc language4
item desc language5
item desc language6  (new value entered user)

there also apparatus pivotal matches any "item description" unparalleled "item desc language". wholly ever going any during interpretation process, times values competence different, apparatus keys can't simply altered indicate during interpretation permanently.

i should also add, there should alteration structure tables stealing rows table.

---

ok, here's an updated revisal i query do, nonetheless apparently does given i indeed need values assimilated table:

select pe.prodtree_element_name_l, rs.resource_value, pe.prodtree_element_name_l_rk   
from prodtree_element pe
        left join resource_shortstrings rs
            pe.prodtree_element_name_l_rk = rs.resource_key
        where rs.language_id = '5'
            pe.prodtree_element_name_l <> ''
        organisation pe.prodtree_element_name_l