A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Joined: Jun 25, 2009
Jun 25, 2009 12:56:48
I need help for querying the bleow data
table 1: column: price_rs
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
Joined: Nov 02, 2005
Jun 25, 2009 13:40:30
What is the relationship between these two tables? No primary key/foreign key relationship?
How the rows are guaranteed to be unique??
Joined: May 26, 2003
Jun 25, 2009 20:22:26
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)
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: sql query
updating rows in table error
Having problem in resetting the value of JTable
ui beginner feedback for JTable handling kindly wanted
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014