We want to create an external lookup where we join our data column with a column in a table in SQL server, but with conditions on the join. Using the checkbox method, we have created many simple joins for previous external lookups that we have done, which is represented by the SQL Code below.

 

 

 

SELECT A.*, B.*

 

FROM OurTable A

 

INNER JOIN LookupSQLTable B

 

ON A.CommonFieldValue = B. CommonFieldValue

 

 

 

However, for the lookup in question, we want to do something that would look like this in SQL code:

 

 

 

SELECT A.*, B.*

 

FROM OurTable A

 

INNER JOIN LookupSQLTable B

 

ON A.CommonField = B.CommonField AND A. CommonFieldValue BETWEEN B.LowValue AND B.HighValue

 

 

 

Is this possible in Monarch? (without a script run from Automator)