Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql query

 
phani ravinutala
Greenhorn
Posts: 26
  • 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
  • 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: 34383
346
Eclipse IDE Java VI Editor
  • 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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic