aspose file tools*
The moose likes Oracle/OAS and the fly likes sql 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 "sql query" Watch "sql query" New topic
Author

sql query

phani ravinutala
Greenhorn

Joined: Jun 25, 2009
Posts: 26
hi all,


I need help for querying the bleow data

table 1: column: price_rs

price_rs
cd:435
cd:425
cd:465


table 2: column: error, message



Can anyone help me to query for the below data?

I want to display the data like below


thanks,
anvi


Sridhar Gudipalli
Ranch Hand

Joined: Nov 02, 2005
Posts: 120
What is the relationship between these two tables? No primary key/foreign key relationship?
How the rows are guaranteed to be unique??


Sridhar Gudipalli|SCJP 6.0
SCWCD objectives
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29274
    
140

Kal,
The first thing is to figure out what to join on. It looks like that would be the number. Can you find the Oracle functions to convert "cd:XXX" into a number? (hint: substring and to number)


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sql query
 
Similar Threads
SQL Error!!
updating rows in table error
Having problem in resetting the value of JTable
JPA [Collections]
ui beginner feedback for JTable handling kindly wanted