Skip to content
Snippets Groups Projects
  • gmantele's avatar
    e03e5725
    [ADQL] Fix the transformation of NATURAL JOIN and JOIN...USING of MS-SQLServer. · e03e5725
    gmantele authored
    In the resulting SQL query, if there are an alias on the joined tables, these
    aliases must be used in the ON clause (instead of the full table name).
    
    For instance, the following ADQL query:
    
    ```sql
      SELECT *
      FROM tableA AS a NATURAL JOIN tableB AS b;
    ```
    
    should be translated into the following SQL:
    
    ```sql
      SELECT *
      FROM tableA AS a
        INNER JOIN tableB AS b
          ON a.id = b.id
    ```
    
    This commit complete the resolution of the Pull Request #16
    (more details about the issue can be got in there)
    e03e5725
    History
    [ADQL] Fix the transformation of NATURAL JOIN and JOIN...USING of MS-SQLServer.
    gmantele authored
    In the resulting SQL query, if there are an alias on the joined tables, these
    aliases must be used in the ON clause (instead of the full table name).
    
    For instance, the following ADQL query:
    
    ```sql
      SELECT *
      FROM tableA AS a NATURAL JOIN tableB AS b;
    ```
    
    should be translated into the following SQL:
    
    ```sql
      SELECT *
      FROM tableA AS a
        INNER JOIN tableB AS b
          ON a.id = b.id
    ```
    
    This commit complete the resolution of the Pull Request #16
    (more details about the issue can be got in there)