Join load limited to primitive table values

[#1]

Hi, this script creates a fourth row in table 'A' with an empty HOTEL.

A:
LOAD * INLINE [
CODE, HOTEL
1,BPT,
2,BPJ,
14,BSA];

JOIN LOAD * INLINE [
CODE, SALE
1,100,
2,125,
14,85,
10,250
];

How could I JOIN LOAD the SALES of CODE '1','2' and '14' FROM the information in second table without adding any new row?

Thanks

[swuehl · Accepted solution]

Try a

LEFT JOIN LOAD

Or look into a mapping solution.