please send me the query

mvivekm21 · Post by **mvivekm21** » Tue Jun 05, 2012 8:29 pm

in db2, i m having the two tables. both tables have no primary key. duplicates are there.
how to fetch the multiple rows from 1st table and insert into the 2nd by comparing the two fields in first table.

DikDude · Post by **DikDude** » Tue Jun 05, 2012 11:07 pm

Your request is not clear.

Suggest you show a few sample rows from both tables and what should be the result when your query is run.

No need for a lot of volume, but enough to show the different possibilities. Only relevant columns need to be showm.

NicC · Post by **NicC** » Wed Jun 06, 2012 10:48 am

Please send the money

Anuj Dhawan · Post by **Anuj Dhawan** » Wed Jun 06, 2012 11:45 am

Well - your subject title seems to be a winner!

And as far as I can make out of your question - most possibly you can use JOIN but then to use that you just tell this

fetch the multiple rows from 1st table

which is not at all sufficient to answer your question, as DikDude also indicates.

cmsmoon · Post by **cmsmoon** » Mon Jun 18, 2012 4:21 pm

INSERT INTO TABLE2 VALUES(COL1,COL2,COL3) SELECT COL1,COL2,COL3 FROM TABLE1 WHERE COL1 = COL3 ;

INSERT INTO T2 (intcol1,identcol2) SELECT intcol1, identcol2
FROM T1
Please refer
http://publib.boulder.ibm.com/infocente ... 000970.htm

DikDude · Post by **DikDude** » Mon Jun 18, 2012 8:28 pm

Did you test the inserts before posting?

How do you know this is what the TS wants?

mainframegurukul.com

please send me the query

please send me the query

FREE TUTORIALS