Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by ZhengShao: http://wiki.apache.org/hadoop/Hive/LanguageManual/Joins ------------------------------------------------------------------------------ | ( table_references ) join_condition: - ON equality_expression + ON equality_expression ( AND equality_expression )* equality_expression: expression = expression @@ -35, +35 @@ {{{ SELECT a.* FROM a JOIN b ON (a.id = b.id) }}} + {{{ + SELECT a.* FROM a JOIN b ON (a.id = b.id AND a.department = b.department) + }}} - is a valid join, however + are both valid joins, however {{{ SELECT a.* FROM a JOIN b ON (a.id <> b.id) }}}
