Run specific query based on dropdown


I am trying to run 1 of 5 queries based on a specific dropdown value. I am still relatively new to Retool, so I am not entirely certain on the options, so any advice is greatly appreciated!

If you post some screenshots it will help me understand the context. Basically, you can pass the value of the select field into the query using {{select field.value}}


Essentially it is a dropdown with three companies (1, 2, or 3) and I need an ID in the SQL to change based on what that company is (and an associated ID).

If you send some screenshots I will try to send you a solution using your variables