hi! i have something like this in a sql expression

(
select
    `table_name`.`a_field_name`
from
    `table_name`
where
    `table_name`.`another_field_name`='parameter'
)

where the parameter is defined in the parameter fields.

i tried to put the parameter like this {?parameter} but it still doesn't work.

can anyone help me?

i don't have a syntax error, but the query returns nothing. i'm using a mysql database.