The FROM clause narrows the search to include only the specified tables (node types). For example, the query
SELECT myapp:productName FROM mynt:shippable
would return all properties in the workspace called myapp:product that belong to nodes of node type mynt:shippable. Note that when a node type is specified in FROM clause the table (in the database view) searched will contain all nodes of the named type plus all node of subtypes of the named type. However the columns available in that table will reflect only those declared or inherited by the named type. To search all node types (tables) one would specify FROM nt:base (though an implementation can always prevent searches whose scope is unfeasibly large). See also 6.6.3.2 Type Constraint.