Hi,

I build a mask that is filtering a table. A script collects the filter inputs and generates a query the following way

(select TABLE)[attribute = VALUE]

However, the returned results are wrong. I do receive the correct results with the following query

select TABLE where attribute = VALUE

So my questions are; How are these two queries different from another? How can I get the correct results from the script, keeping in mind that I have a few more attributes I filter by and not all have to be set?