SELECT [ALL| DISTINCH TOP nExpr IPERCENITI
Select_List Item L .- FROM [FORCE] Table_List Item L.-]
[WITH(BUFFERING =IExpr] IlJoinType] JOIN DatabaseName!]
Table [[AS] LocaLAlias]
[ON JoinCondition [ANDOR JoinCondition!FilterCondition]...]
[WHERE JoinConditionFilterCondition ANDOR JoinCondition! FilterCondition] ...]
[GROUP BY Column List Item L ...]]
[HAVING FilterCondition [ANDIOR ..]I[UNION [ALL] SELECTCommand]
[ORDER BY Order_Item [ASCIDESC] [.....]]
[StorageDestinationDisplayDestination]
[PREFERENCE PreferenceName] INOCONSOLE] [PLAINJINOWAIT
JoinType-INNERILEFTRIGHTI FULL [OUTER]
StorageDestination -INTO [ARRAY ArrayName!
CURSOR CursorName[NOFILTER!READWRITE]ITABLE TableName]
DisplayDestination-TO [FILE FleName [ADDITIVE]
IPRINTER PROMPTISCREENJSELECT [ALL| DISTINCH
TOP nExpr IPERCENITI Select_List Item L .-
FROM [FORCE] Table_List Item L.-][WITH(BUFFERING =IExpr] IlJoinType]
JOIN DatabaseName!]Table [[AS] LocaLAlias]
[ON JoinCondition [ANDOR JoinCondition!FilterCondition]...]
[WHERE JoinConditionFilterCondition ANDOR JoinCondition! FilterCondition] ...]
[GROUP BY Column List Item L ...]]
[HAVING FilterCondition [ANDIOR ..]I[UNION [ALL] SELECTCommand]
[ORDER BY Order_Item [ASCIDESC] [.....]][StorageDestinationDisplayDestination]
[PREFERENCE PreferenceName] INOCONSOLE] [PLAINJINOWAIT
JoinType-INNERILEFTRIGHTI FULL [OUTER]
StorageDestination -INTO [ARRAY ArrayName!
CURSOR CursorName[NOFILTER!READWRITE]ITABLE TableName]
DisplayDestination-TO [FILE FleName [ADDITIVE]IPRINTER PROMPTISCREENJ
分界
选择[ all | distinch top nexpr iperceniti select _ list item l。-
from [ force ] table _ list item l.-][ with (buffering = iexpr ] iljointype ]
join databasename! ][[ as ] localalias ][ on joincondition [ andor joincondition! filtercondition ] ... ]
[ where joinconditionfiltercondition 和/或 joincondition![过滤条件] ... [按列列表项目 l... ][具有过滤条件[安迪或]。.
]I [ union [ all ] selectcommand ][ order by order item [ ascidesc ][ ... ]
[ storagedestinationdisplaydestination ][ preference preferencename ] inoconsole ][ plainjinowait jointype-innereftrighti full [ outer ]
storagedestination-into [ array arrayname!光标修改名称[ nofilter! readwrite ] itable tablename
显示目的地到[ file flename [ additive ] iprinter prompttiscreenjselect [ all |
distinch top nexpr iperceniti select _ list item l。- from [ force ] table _ list item l.-]
[ with (buffering = iexpr ] iljointype ] join databasename! ][[ as ] localalias ]
[ on joincondition [ andor joincondition! filtercondition ] ... ][ where joinconditionfiltercondition
和/或 joincondition![过滤条件] ... [按列列表项目 l... ][具有过滤条件[安迪或]。.]I [ union [ all ]
selectcommand ][ order by order item [ ascidesc ][ ... ][ storagedestinationdisplaydestination ][ preference preferencename ]
inoconsole ][ plainjinowait jointype-innereftrighti full [ outer ] storagedestination-into [ array arrayname!
光标曲线名[ nofilter! readwrite ] itable tablename 显示目的地到[文件 flename [ add ]打印机提示符
二次分界
所有 distinch top nexpr iperceniti 选择列表项目从强制表列表项目与缓冲 iexpr iljointypejoin
数据库名称!作为当地的合并条件或合并条件!其中连接条件过滤条件
我把所有的选择命令按顺序合并到一个项目 ascidesstorage/目的地/目的地/目的地优先选择名称控制台 jinowait jointype/innereftrighti full outer
/目的地/目的地/目的地/目的地/目的地/目的地/目的地/目的地/
文件名添加剂 iprinter prompttiscreenjselect all distinch top nexpr iperceniti select list item
from force table list item with buffering iexpr iljointype join databasename!作为当地的合并条件或合并条件!过滤条件,其中连接条件过滤条件
I union all select command order by order item ascidesc storage/目的地/目的地/目的地/目的地/目的地/目的地/目的地/目的地/
目的地/目的地/目的地/目的地/目的地/目的地/目的地/目的地/目的地!
有时一条语句,也够人折腾的。不懂外语的悲哀!