Is there a way to grab the value of a column field in a table from a SQL query? Normally you can select variables through SQL with this syntax: '${variable}' but I want to select the value from a column named 'col1' from table 'table1'. I've tried using arrangements like '${table1:col1}' and '${table1~col1}' but to no avail.
Thanks
