java.lang.Object
- adql.query.from.ADQLJoin
- - adql.query.from.InnerJoin
  - - adql.query.from.SQLServer_InnerJoin

All Implemented Interfaces:

ADQLObject, FromContent
```
public class SQLServer_InnerJoin
extends InnerJoin
```
Special implementation of InnerJoin for MS SQL Server.

Important: Instances of this class are created only by SQLServer_ADQLQueryFactory.

This implementation just changes the behavior the getDBColumns(). In MS SQL Server, there is no keyword NATURAL and USING. That's why the DBColumns returned by DBColumn can not contain any DBCommonColumn. Instead, the DBColumn of the first joined table (i.e. the left one) is returned.

Since this special behavior is also valid for OuterJoin, a special implementation of this class has been also created: SQLServer_OuterJoin. Both must have exactly the same behavior when getDBColumns() is called. That's why the static function getDBColumns(ADQLJoin) has been created. It is called by SQLServer_InnerJoin and SQLServer_OuterJoin.

Since:

1.4

Version:

1.4 (03/2016)

Author:

Grégory Mantelet (ARI)

See Also:

SQLServer_ADQLQueryFactory

Field Summary
- Fields inherited from class adql.query.from.ADQLJoin
  condition, lstColumns, natural

Constructor Summary

Constructors
Constructor	Description
`SQLServer_InnerJoin(FromContent left, FromContent right)`	Builds a NATURAL INNER JOIN between the two given "tables".
`SQLServer_InnerJoin(FromContent left, FromContent right, ClauseConstraints condition)`	Builds an INNER JOIN between the two given "tables" with the given condition.
`SQLServer_InnerJoin(FromContent left, FromContent right, java.util.Collection<ADQLColumn> lstColumns)`	Builds an INNER JOIN between the two given "tables" with the given condition.
`SQLServer_InnerJoin(InnerJoin toCopy)`	Builds a copy of the given INNER join.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`static void`	`addAllExcept2(SearchColumnList itemsToAdd, SearchColumnList target, java.util.Map<java.lang.String,DBColumn> exception)`
`SearchColumnList`	`getDBColumns()`	Gets the list of all columns (~ database metadata) available in this FROM part.
`static SearchColumnList`	`getDBColumns(ADQLJoin join)`	Gets the list of all columns (~ database metadata) available in this FROM part.

Methods inherited from class adql.query.from.InnerJoin
getCopy, getJoinType

Methods inherited from class adql.query.from.ADQLJoin
addAllExcept, adqlIterator, findAtMostOneColumn, findExactlyOneColumn, getJoinCondition, getJoinedColumns, getLeftTable, getName, getPosition, getRightTable, getTables, getTablesByAlias, hasJoinedColumns, isCommonColumn, isNatural, setJoinCondition, setJoinedColumns, setLeftTable, setNatural, setPosition, setRightTable, toADQL

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - SQLServer_InnerJoin
```
public SQLServer_InnerJoin(FromContent left,
                           FromContent right)
```
    Builds a NATURAL INNER JOIN between the two given "tables".
    
    Parameters:
    
    left - Left "table".
    
    right - Right "table".
    
    See Also:
    
    InnerJoin(FromContent, FromContent)
  - SQLServer_InnerJoin
```
public SQLServer_InnerJoin(FromContent left,
                           FromContent right,
                           ClauseConstraints condition)
```
    Builds an INNER JOIN between the two given "tables" with the given condition.
    
    Parameters:
    
    left - Left "table".
    
    right - Right "table".
    
    condition - Join condition.
    
    See Also:
    
    InnerJoin(FromContent, FromContent, ClauseConstraints)
  - SQLServer_InnerJoin
```
public SQLServer_InnerJoin(FromContent left,
                           FromContent right,
                           java.util.Collection<ADQLColumn> lstColumns)
```
    Builds an INNER JOIN between the two given "tables" with the given condition.
    
    Parameters:
    
    left - Left "table".
    
    right - Right "table".
    
    lstColumns - List of columns to join.
    
    See Also:
    
    InnerJoin(FromContent, FromContent, Collection)
  - SQLServer_InnerJoin
```
public SQLServer_InnerJoin(InnerJoin toCopy)
                    throws java.lang.Exception
```
    Builds a copy of the given INNER join.
    
    Parameters:
    
    toCopy - The INNER join to copy.
    
    Throws:
    
    java.lang.Exception - If there is an error during the copy.
    
    See Also:
    
    InnerJoin(InnerJoin)
- Method Detail
  - getDBColumns
```
public SearchColumnList getDBColumns()
                              throws UnresolvedJoinException
```
    Description copied from interface: FromContent
    
    Gets the list of all columns (~ database metadata) available in this FROM part.
    
    Note: In the most cases, this list is generated on the fly !
    
    Specified by:
    
    getDBColumns in interface FromContent
    
    Overrides:
    
    getDBColumns in class ADQLJoin
    
    Returns:
    
    All the available DBColumns.
    
    Throws:
    
    UnresolvedJoinException - If a join is not possible.
  - getDBColumns
```
public static SearchColumnList getDBColumns(ADQLJoin join)
                                     throws UnresolvedJoinException
```
    Gets the list of all columns (~ database metadata) available in this FROM part. Columns implied in a NATURAL join or in a USING list, are not returned as a DBCommonColumn ; actually, just the corresponding DBColumn of the left table is returned.
    
    Returns:
    
    All the available DBColumns.
    
    Throws:
    
    UnresolvedJoinException - If a join is not possible.
  - addAllExcept2
```
public static final void addAllExcept2(SearchColumnList itemsToAdd,
                                       SearchColumnList target,
                                       java.util.Map<java.lang.String,DBColumn> exception)
```

Class SQLServer_InnerJoin

Field Summary

Fields inherited from class adql.query.from.ADQLJoin

Constructor Summary

Method Summary

Methods inherited from class adql.query.from.InnerJoin

Methods inherited from class adql.query.from.ADQLJoin

Methods inherited from class java.lang.Object

Constructor Detail

SQLServer_InnerJoin

SQLServer_InnerJoin

SQLServer_InnerJoin

SQLServer_InnerJoin

Method Detail

getDBColumns

getDBColumns

addAllExcept2