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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-16 : 07:44:32
|
| Godwin writes "Hello,Heres my question..I have 2 tables.2 paticular columns exist in both the tables.I want to be able to select those 2 columns on the 1st table and insert them on to the same 2 columns on the 2nd table.Now,this 2nd table has another 3 columns that exist in another table.I would like to take those 3 column values from that 3rd table and insert it into the 2nd table by modifying those existing records in the 2nd table.In the 3rd table,there will be around 5 records...I want to copy the existing records 5 times in the 2nd table and insert the 3rd tables rows inside the 2nd table in that respective column for 5 rows.I hope you understand what I mean...Im sorry for really confusing..Please help meThanksGodwin" |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-02-16 : 10:48:26
|
| Posting your tables and sample data would really help. Not sure how 3rd table related to 2nd table. |
 |
|
|
|
|
|
selecting records from one column in a table and inserting..