MS SQL SELECT Statement Sources
SELECT *
FROM
tables(s)
subqueries (as derived tables) AS NamedRangeAlias
common table expressions (CTE)
views
table-valued user-defined functions
distributed data sources (OpenQuery)
XML data sources (XQuery)