Join load limited to primitive table values

Sat, 06 Jul 2013 21:40:33 GMT

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

Re: Join load limited to primitive table values

swuehl — Sat, 06 Jul 2013 22:48:51 GMT

Try a

LEFT JOIN LOAD

Or look into a mapping solution.