Re: Query execution based on a condition

Change the conditions of other 3 queries, so those shall give empty row sets depending on your value.

29.12.2012, 23:06, "JORGE MALDONADO" <jorgemal1960@gmail.com>:
> I have a query similar to the one shown below but, depending on the value of a field, only the first SELECT statement
shoudexecute and the other 3 should be ignored. Is there a way to achieve this situation?
 
>
> SELECT fields FROM tblTable WHERE condition
> UNION
>
> SELECT fields FROM tblTable WHERE condition
>
> UNION
>
> SELECT fields FROM tblTable WHERE condition
> UNION
>
> SELECT fields FROM tblTable WHERE condition
>
> Respectfully,
> Jorge Maldonado