File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql query

 
phani ravinutala
Greenhorn
Posts: 26
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 120
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the relationship between these two tables? No primary key/foreign key relationship?
How the rows are guaranteed to be unique??
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33694
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic