sqlQuery statement
The sqlQuery statement lets you use a SQL Query “SELECT” statement to manipulate any result set. A result set is any data returned by an Enesys SharePoint Query statement ( list , mergeLists , rollUpLists , sqlQuery …).
<sqlQuery tableName=""> SELECT … </sqlQuery>sqlQuery attributes
Section titled “sqlQuery attributes”tableName
Section titled “tableName”Name of the destination table for holding the result of the SELECT operation. The result of this operation can be used as part of another operation by invoking this name.