How to update field in one table from another table if exists

[#1]

I'm new to QlikView and I'm asked to duplicate an Oralce SQL script into QlikView.  The Oracle SQL loads a table with Insert and Select and then Updates 1 field in this table from another table if it finds a match.  Using the example tables below, Table 1 is loaded; it has a Location field.  Table 2 is loaded; it also has a Location field.  Then the UPDATE statement is used to change the location in Table 1 if a match is found in Table 2.  How can I accomplish this in QlikView beyond the simple LOAD and SQL SELECT to load the 2 tables?

Example:

Table 1
Key	Location
A	1F
B	2G
C	5B
F	9X

Table 2
Key	Location
A	9ABC
G	J4

The resulting Table 1 would be:

Table 1
Key	Location
A	9ABC
B	2G
C	5B
F	9X

Thanks for considering my question.