data transfer could any one help

i hv got following tables

 

table1

 

 title        form      vol      issue

dssc        23         12       5

fdfa          11         33         4

dssaa        43        23         5

wqee         112       76        4

 

 

table2

 

formname     id

werd            23

sql               11

dera            43

qsdv             112

 

i transferred data of table2 new table3 new id

 

formname     formid 

werd            145

sql               655

dera            656

qsdv             657

 

 

i created new table vol transferringdata table1

 

volid    formid    vol

123       145       12

124        655       33

125        656       23

126         657      76

 

 

i creayted table issue transferred data table1

 

issueid     issue    formid   volid

221           5          145     123

222           4           655     124

223           5          656      125

224          4            657       126

 

 

now need transfer data table1 table  form

 

 title        formid      volid      issueid

dssc        145         123      221

fdfa          655         124         222

dssaa        656        125         223

wqee         657       126       224

 

i tried best couldnrt correct ans

 

any 1 help

 

before inserting data in table try use view designer tool create select  ; in way can  drag , drop the apropriate relations in query , see if select return data.

 

 

SQL Server  >  Getting started with SQL Server