Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lydia
Starting Member
34 Posts |
 Posted - 2012-07-25 : 02:41:51
|
| Hi all ! I have two tables, table a have(suba,subb,calling,called)and table b have (suba,subb,calling,called,charge,sms,balance.....)I would like to get all suba from table b insert into table a only one colum.Could you please tell me how can I inser data to table a ? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-25 : 02:45:31
|
Do you mean this?insert TableA(suba) select suba from TableBIf not then please make it more clear.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
lydia
Starting Member
34 Posts |
Posted - 2012-07-25 : 02:54:03
|
| haha......yes, it is correct.just insert Table a (suba) select suba from TableB.Thank you very much darling :) |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-25 : 02:55:59
|
my pleasure - darling 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
insert into specific colum