2004 IR Help Posted September 2, 2006 Share Posted September 2, 2006 By: anuj - anujs_iitd viewing fields with same name in diff tables 2004-07-01 02:57 I am having problems with attaching queries where i want to see fields with same name but in different tables adn the error comes that it cannot differentiate in the two. I used a query like select students.name , class.name from students,class where students.name='anuj' helppppppppppppppppppppppp By: Giulio Toffoli - gt78 RE: viewing fields with same name in diff tables 2004-07-01 09:07 use alias: select students.name as STUDENT_NAME, class.name as CLASS_NAME from students,class where students.name='anuj' Giulio Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now