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 - 2001-09-27 : 22:48:06
|
| Deva writes "For example, I have a table called lookup_table(code,value1,value2) and values for the table are 1,name,peter2,address,fort stI have another table called Detail_table(Code,name,address) and I need to populate this table using the lookup_table as1,peter,null2,null,fort stThis means, the value1 in the lookup_table refers to the column name in Detail_table. value2 in the lookup_table is the actual value for the Detail_table.I appreciate your help.Thanks,Deva" |
|
|
|
|
|
data in the lookup_table refers to the column name in another table