File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
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: 133
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