Multi-Select query help

[memory721]

Hello,

I'm having trouble with my query when I try to create a multi-select input control.

Here is my code in iReport:

SELECT r.rule_name, f1.value, r.id, rb.rule_builder_name, f2.value AS f2value, rc.category_name, f3.value AS f3value
FROM
  rules r, rule_builders rb, rule_categories rc, flex_labels f1, flex_labels f2, flex_labels f3
WHERE
  f1.hierarchy_id=r.hierarchy_id
  AND f1.fieldvalue=r.rule_name
  AND rb.id=r.rule_builder_id
  AND f2.fieldvalue=rb.rule_builder_name
  AND rc.hierarchy_id=f3.hierarchy_id
  AND f3.fieldvalue=rc.category_name
  AND $X{IN,f3.value, f3value}
  Order by
  f3.value ASC,
  f1.value ASC

For my input control query, I have: 

Select f3.value from flex_labels f3.  I keep getting an error.  I've changed the syntax a few times to try and see if Select value from f3 would work better and different variations of that select statement, but it's not working.  Any suggestions would be greatly appreciated.