Filter and join two tables where a number from one table is between the min and max values in the other table

@gcarmich​ SQLite support a BETWEEN operator that might simplify your query in the InlineQuerier. If you include a small sample dataset someonemight be able to illustrate the query

Unfortunately, the BETWEEN operator is always inclusive: it tests for greater than or equal to the lower value, and less than or equal to the higher value.

In this case an exclusive range was needed, so the greater than (>) and less than operators (<) have to be used.

@gcarmich​ @geomancer​ Just a quick FYI note on performance in the InlineQuerier . 

FME creates an fme_feature_content attribute that contains the entire feature on the input (i.e. all the input attributes) . 

In the Columns section of the Inputs: only include the attributes that you'll explicitly use in your SQL queries  (see the section Configuration -  Inputs of the InLineQueir docs). So, in the example below,  if you're creating a simple JOIN using RECORDID, remove all the other attributes. They'll be preserved in the fme_feature_content and you'll have a much lighter SQLite in memory database.  

and your SQL might look something like:

SELECT "CellTower".*, "CellTowerDetail",* FROM "CellTower"
INNER JOIN "CellTowerDetail" 
ON "CellTower"."RECORDID" = "CellTowerDetail"."RECORDID";

In your example above, you'd have to include the "sys_time" , low" and "high" in the Columns

Why clean-up Columns...?

• You're creating tables that contain many more attributes than you need which will take longer to load and create a larger in memory SQLite database than you need
• All Columns attributes are indexed.  So for larger data datasets with many attributes that's a lot of indexing