zaagan
8/20/2019 - 11:06 AM

MS SQL SELECT Statement Sources

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)