How does using cacheKey and lookup behave?

[Kaushik]

I use the cacheKey, cacheLookup, SortedMapBackedCache in the Data Import
Handler of Solr 5.x to join two or more entities. Does this give me an
equivalent of Sql's inner join? If so, how can I get something similar to
left join?

Thank you,
Kaushik