View previous topic :: View next topic
|
Author |
Message |
sandy_mcs
New User
Joined: 01 Apr 2006 Posts: 17 Location: Pune
|
|
|
|
I have two tables of the same structure.
Now, i want to sent data from one table to another table which is empty
How can i do this in a single query..! |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy sandy_mcs,
yes you can do this...
combine your insert statement with the select from of the
source table....
INSERT INTO target-table
SELECT *
FROM source-table
WHERE where-clause;
martin9 |
|
Back to top |
|
|
balusengodan
New User
Joined: 01 Mar 2005 Posts: 15 Location: chennai
|
|
|
|
hi martin ,
u r absolutely right u can do this we can also use load but i am not clear about this bcz i have n't used this i read in some books we can able to load data of one table to another table with the help of load command
thanks
balu.s |
|
Back to top |
|
|
|