EXECUTE

The EXECUTE Command is used to execute a SQL statement against the current TARGITDB, much the same as with 'ME', storing the results back into the TARGITDB.
Syntax:
EXECUTE table_to_store_results_as = { some_SQL_command in curly bracks }
Example:
EXECUTE Combined_Sales = {SELECT 2.0 as currency_factor, [order details].UnitPrice AS unit_price, [Order Details].Quantity, [Order Details].costprice, Orders.CustomerID, Orders.EmployeeID,Orders.ShipVia, [Order Details].ProductID,   Products.CategoryID, Products.SupplierID, Orders.OrderID, Orders.OrderDateFROM [Order Details] INNER JOIN Orders ON [Order Details].OrderID = Orders.OrderID INNER JOIN Products ON [Order Details].ProductID = Products.ProductID }