What are the differences between join and lookup?

[changwoo]

What are the big differences?

[bing_wu_mash]

Also - if you are from DB/SQL background, keep in mind LOOKUP is like LEFT OUTER JOIN whereas JOIN is like INNER JOIN. The results are quite different

[highsplunker]

excellent. this is exactly what's important.

i'd also add this: there's No difference between "left join" and "left OUTER join".

ref. https://stackoverflow.com/questions/406294/left-join-vs-left-outer-join-in-sql-server

[bing_wu_mash]

Also - if you are from DB/SQL background, keep in mind LOOKUP is like LEFT OUTER JOIN whereas JOIN is like INNER JOIN

[MuS · Accepted solution]

Hi changwoo,

A join is used to combine the results of a search and subsearch if specified fields are common to each. You can also join a table to itself using the selfjoin command.

Use the lookup command to manually invoke field lookups from a lookup table that you've defined in transforms.conf. For more information, see "Lookup fields from external data sources," in the Knowledge Manager manual.

hope this helps ...

cheers, MuS

[changwoo]

thanks for your help