sql query

[phani ravinutala]

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

error     message
435       proramming error
425       syntax error
465       business error

Can anyone help me to query for the below data?

I want to display the data like below

price_rs      error     message

cd:435    435        proramming error
cd:425    425        syntaxerror
cd:465    465        business error

thanks,
anvi

[Sridhar Gudipalli]

What is the relationship between these two tables? No primary key/foreign key relationship?
How the rows are guaranteed to be unique??

[Jeanne Boyarsky]

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)