5,2使用 SELECT语句查询数据 523FRoM子句 I FROMi table source >In] table source >1= table name[[ as] table alias ][ WIth ( table_ hint >[un ])I view name[[ as i table alias I rowset function [ as table alias I OPENXML I derived table As table alias I column_ alias ln I< joined _table
5.2 使用SELECT语句查询数据 5.2.3 FROM子句 [ FROM { < table_source > } [ ,...n ] ] < table_source > ::= table_name [ [ AS ] table_alias ] [ WITH ( < table_hint > [ ,...n ] ) ] | view_name [ [ AS ] table_alias ] | rowset_function [ [ AS ] table_alias ] | OPENXML | derived_table [ AS ] table_alias [ ( column_alias [ ,...n ] ) ] | < joined_table >
5,2使用 SELECT语句查询数据 joined_table >i:= table_ source><join_type> <table source>on<search condition> table source CRoSS JoIN table source joined _table ≤join_type>:= I INNERi LEFT RIGHT FULL 1 [ OUTER]了] [< join_ hint >] 基本格式 JOIN
5.2 使用SELECT语句查询数据 < joined_table > ::= < table_source><join_type> <table_source>ON<search_condition> | < table_source > CROSS JOIN < table_source > | < joined_table > < join_type > ::= [ INNER | { { LEFT | RIGHT | FULL } [OUTER] } ] [ < join_hint > ] JOIN 基本格式