hope this fix your issue I would like to perform a lookup in presto where table is contains my lookup column "lookup_code" and tableb has a range lookup_range_description that i want to return , You may want to use LEFT OUTER JOIN with BETWEEN like this.
from TableA a
left outer join TableB b
on a.lookup_code between b.start_ and b.end_
seems to work fine As you've identified there are two main choices; On the one hand you could have many identically structured lookup tables. The disadvantage of this approach is the apparent duplication of an identical table structure. It looks like a form of duplication which you no doubt want to avoid.
Hope that helps NHibernate only complains if the specified keygenerator doesn't support the type. I guess you haven' specified any generator which defaults to identity which can only handle integral types. with assigned you could provide the ids
Id(x => x.Id).GeneratedBy.Assigned();
In a single MySQL query lookup one column's value in another table
This might help you I would like to be able to replace zero values in a data frame using a lookup table of replacement values, where the replacement value is different for each column. Trust that the simple example below explains the problem and the desired outcome. , An option with base R