Is there a way in ZEN to develop SQL queries? I have been doing this in Tivoli and would like to find a way in ZEN. For instance I would like to be able to set up something like this:
(PACKAGE_NAME like 'Mozilla Thunderbird %')

AND
"TME_OBJECT_LABEL" NOT IN
(select "TME_OBJECT_LABEL"
from "NATIV_SWARE_VIEW"
where "PACKAGE_NAME" = 'Mozilla Thunderbird (2.0.0.22)')

order by TME_OBJECT_LABEL
Of course the tables and the column names would be different.
I just do not see how to apply the operators that are available in ZEN to accomplish this.