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