This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Issues in retrieving results using a Query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Issues in retrieving results using a Query" Watch "Issues in retrieving results using a Query" New topic

Issues in retrieving results using a Query

Varshini Priya
Ranch Hand

Joined: Feb 17, 2008
Posts: 94


Im trying to retrieve two different values from the same field for a single record using a query. My query is something like this

In the above query, Im trying to get the user, instructor id and instructor name from the user table. But Im not able to retrieve the correct results. I have also tried creating an alias name for the user table but still not able to get the complete list. Im getting duplicate records as well. please Advise

John Bengler
Ranch Hand

Joined: Feb 12, 2009
Posts: 133
Hi Varshini,

maybe this thread can help you. Have especially a closer look at the example with the EMP table:

Using Aliases

I agree. Here's the link:
subject: Issues in retrieving results using a Query
jQuery in Action, 3rd edition