MySQL Teradate equivalent

Question

My question is very similar to this, but in Teradata:

SQL Server equivalent of USING MySQL

Is there an equivalent shortcut for this request?

SELECT * 
  FROM t1 
  JOIN t2 
    ON (t1.column = t2.column)

Answer 1

No. The closest you can do with a natural mix:

SELECT
FROM T1, T2
WHERE t1.column = t2.column;

Answer 2

Yes. This is the ANSI JOIN syntax. For instance:

SELECT
   *
FROM T1
   INNER JOIN T2 ON T1.column = T2.column
;

For criteria for combining multiple columns, follow these steps:

SELECT
    *
FROM T1
   INNER JOIN T2 ON T2.column1 = T1.column1
      AND T2.column2 = T1.column2
   LEFT OUTER JOIN T3 ON T3.column1 = T2.column1 
;

Detailed, comprehensive information with examples is available in Chapter 2 of the Teradata® RDBMS SQL Reference - Volume 6 Data manipulation statements .

Answer 3

Teradata NATURAL JOINs, . MySQL, NATURAL JOINs - INNER JOINs USING. , LEFT | RIGHT OUTER NATURAL, , JOIN.

Check the Teradata documentation, I hope it should support it.