[
https://issues.apache.org/jira/browse/TAJO-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14152713#comment-14152713
]
ASF GitHub Bot commented on TAJO-1068:
--------------------------------------
Github user hsaputra commented on a diff in the pull request:
https://github.com/apache/tajo/pull/155#discussion_r18195877
--- Diff: tajo-docs/src/main/sphinx/sql_language/queries.rst ---
@@ -23,16 +23,234 @@ Overview
From Clause
=====================
+*Synopsis*
+
+.. code-block:: sql
+
+ [FROM <table reference> [[AS] <table alias name>] [, ...]]
+
+
+The ``FROM`` clause specifies one or more other tables given in a
comma-separated table reference list.
+A table reference can be a relation name , or a subquery, a table join, or
complex combinations of them.
+
+----------------------
+Table and Table Aliase
+----------------------
+
+A temporary name can be given to tables and complex table references to be
used
+for references to the derived table in the rest of the query. This is
called a table alias.
+
+To create a a table alias, please use ``AS``:
+
+.. code-block:: sql
+
+ FROM table_reference AS alias
+
+or
+
+.. code-block:: sql
+
+ FROM table_reference alias
+
+The ``AS`` keyword can be omitted, and *Alias* can be any identifier.
+
+A typical application of table aliases is to give short names to a long
table references. For example:
+
+.. code-block:: sql
+
+ SELECT * FROM long_table_name_1234 s JOIN another_long_table_name_5678 a
ON s.id = a.num;
+
+-------------
+Joined Tables
+-------------
+
+Tajo supports all kinds of join types.
+
+Join Type
--- End diff --
"Join Types" instead of "Join Type" to be consistent with the rest of the
doc.
> Add SQL Query documentation
> ---------------------------
>
> Key: TAJO-1068
> URL: https://issues.apache.org/jira/browse/TAJO-1068
> Project: Tajo
> Issue Type: Sub-task
> Components: documentation
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Priority: Minor
> Fix For: 0.9.0
>
>
> See the doc:
> http://tajo.apache.org/docs/current/sql_language/queries.html
> This doc is incomplete, and we need to fill this doc.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)