TSL语言基础 > SQL基础到TS-SQL > TS-SQL语法 > SELECT查询语句 > From子句

语法    

  • FROM { < table_source > } [ ,...n ]
    <table_source>::=
    <Expression | THISGROUP|INFOTABLE 基本面表ID |
    {
    <MARKETTABLE | TRADETABLE>
    [DateKey BegTime TO EndTime]
    [OF <StockID|StockIDArray>]
    }|{<SQLTABLE | HUGESQLTABLE [KEEPNULL]><SQL_Str><OF SQL_Alias>}>
    | <joined_table>

    < joined_table > ::=< table_source >< join_type >< table_source >< ONWithExp >| < table_source > CROSS JOIN < table_source >| < joined_table >

    < join_type > ::=[{ LEFT | RIGHT | FULL } ]JOIN

    < ONWithExp > ::=
    {ON < search_condition >} | { WITH (Expression[,...n] ON Expression[,...n]) }