File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Sample SQL question
Joined: Nov 21, 2009
Dec 13, 2009 01:24:30
I have a table that kind of looks like this
eID FIRSTNAME LASTNAME 1 Tom Smith 2 Sam Smith 3 Jack Smith
And another table that looks like this
eID SALARY FIRSTNAME LASTNAME 1 1000 2 2000 3 3000
What is the right query to take the firstname lastname from table one and insert it to table 2 so that the name matches with id and would look like this
eID SALARY FIRSTNAME LASTNAME 1 1000 Tom Smith 2 2000 Sam Smith 3 3000 Jack Smith
I tried one query before but it does not matches the info
Joined: Jul 20, 2005
Dec 13, 2009 01:36:36
What's the question?
Joined: Dec 10, 2009
Dec 13, 2009 05:03:59
I think you may want to explore the
function of SQL for this case.
I agree. Here's the link:
subject: Sample SQL question
Search Query Problem
Help needed with ResultSet
That's what I meant by tough EJB-QL
Display the sequence numbers on the output rows of a select in Oracle 10g
Primary Key Autogeneration for InheritenceType. TABLE_PER_CLASS
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015