aspose file tools*
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Issues in retrieving results using a Query" Watch "Issues in retrieving results using a Query" New topic
Author

Issues in retrieving results using a Query

Varshini Priya
Ranch Hand

Joined: Feb 17, 2008
Posts: 93

Hi

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

Regards,
Varshini
John Bengler
Ranch Hand

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

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

Using Aliases



John
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Issues in retrieving results using a Query
 
Similar Threads
Inner Join
sql query
Help with Hibernate Criteria
search
problem persisting an object with collections and manytomany relationship