Sub Selects?

[rgski]

Is it possible to have subselects within Vortex?

For example:

<SQL "select capital from State where state not in (select exiled_state from old_state)">
$capital
</SQL>

To capitialize on the speed of the appliance vs running the quaries via PHP, I need to be able to build complex sql statements and dynamic interfaces that are built based upon the DBWalker results.

[mark]

Yes.

But that doesn't really apply to the appliance because the scripts are not really accessible except by special arrangement with Thunderstone.