hi guys,

I just need to get it out. It's about SQL syntax.

Where on the internet does it say that you can not use expressions with the IIF function?

IIF( boolean_expression, true_value, false_value )

It turns out that true and false values may only be simple values. Not expressions.

So how does one use different subqueries to evaluate some "where" clause criteria based on the value of some column of the "parent select"?