Keyword USING while joining the tables

Database
Enthusiast

Keyword USING while joining the tables

Hi All,

I know in Oracle, we can join 2 tables using "USING" Keyword for example

SELECT STUDENT_NAME, DEPARTMENT_NAME FROM STUDENT

JOIN DEPARTMENT USING (DEPARTMENT_ID)

This works fine in Oracle as long as I dont pull out DEPARTMENT_ID in my select statement.

Does this work in TD? When I wrote a query, it has given me an error saying that 'ON' is expected after table name.

I do not have TD SQL documentation with me to check whether this possible and Possibly I am not smart enough to seach the web with appropriate keyword or google does not seem smart enough to identify the difference between USING keyword and using verb... :P

Thanks!

Tags (1)
1 REPLY
Enthusiast

Re: Keyword USING while joining the tables

Teradata doesn't recognize the USING clause in joins.  You must use the equivalent ON clause.