| regarding merging of tables [message #70362] |
Mon, 03 June 2002 23:14  |
Sreedhar
Messages: 30
Registered: March 2000
|
Member |
|
|
hi,
i need to merge three tables of same structure, with data into one table. could any one help me out please.
regards,
sreedhar
|
|
|
|
| Re: regarding merging of tables [message #70363 is a reply to message #70362] |
Tue, 04 June 2002 00:13  |
Sujit Mahapatra
Messages: 19
Registered: March 2002
|
Junior Member |
|
|
Try this:
INSERT INTO MERGE_TABLE (SELECT * FROM TABLE1);
Then the other two:
INSERT INTO MERGE_TABLE (SELECT * FROM TABLE2);
INSERT INTO MERGE_TABLE (SELECT * FROM TABLE3);
this should work...
Cheers,
Sujit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
