How to write or use GUI to make query to return entries based on values in another table

[goedible]

How can I make a query to return entries where degrees C is within the range defined in the Min Max fields of the Temp Table?

Check the attached image

[RobertG]

Switch GUI off. I hope “Temp” contains only one row, because you didn’t connect the 2 tables:

SELECT * FROM "Germination Temp. Min°C", "Temp" 
WHERE "°C" BETWEEN "MinTempC" AND "MaxTempC"