All Forums Database
AB75151 20 posts Joined 06/09
02 May 2012
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:
Jim Chapman 449 posts Joined 09/04
02 May 2012

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

You must sign in to leave a comment.