[drill] branch gh-pages updated: MD-5071

[br...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git


The following commit(s) were added to refs/heads/gh-pages by this push:
     new 34601a1  MD-5071
34601a1 is described below

commit 34601a116281096479bf0e0a6cbf337536fe5d65
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Fri Jan 18 13:55:12 2019 -0800

    MD-5071
---
 _docs/sql-reference/sql-commands/079-select.md | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/_docs/sql-reference/sql-commands/079-select.md b/_docs/sql-reference/sql-commands/079-select.md
index 19c17d1..1865f80 100644
--- a/_docs/sql-reference/sql-commands/079-select.md
+++ b/_docs/sql-reference/sql-commands/079-select.md
@@ -1,6 +1,6 @@
 ---
 title: "SELECT"
-date: 2018-12-04
+date: 2019-01-18
 parent: "SQL Commands"
 ---
 Drill supports the following ANSI standard clauses in the SELECT statement:
@@ -56,14 +56,14 @@ The following types of join syntax are supported:
 | ON join in FROM clause         | FROM table1 JOIN table2 ON table1.col1=table2.col1 |
 
 
-You must specify a join condition when more than one table is listed in the FROM clause.
 
-Non-equijoins are supported if the join also contains an equality condition on
-the same two tables as part of a conjunction:
 
-    table1.col1 = table2.col1 AND table1.c2 < table2.c2
+- You must specify a join condition when more than one table is listed in the FROM clause.  
+- Non-equi joins are supported if the join is an inner join with an equality condition on the same two tables as part of a conjunction:  
+  
+		table1.col1 = table2.col1 AND table1.c2 < table2.c2
 
-This restriction applies to both inner and outer joins.
+	Drill does not support non-equi joins as outer joins.
 
 ## Subqueries