Hello all,
I'm trying combine 2 tables data into a single table. My tables look
like this
Table1
ID int 4
filename nvarchar 25
incident nvarchar 50
dreport nvarchar 10
treport nvarchar 7
doccur nvarchar 10
DateOccured datetime 8
toccur nvarchar 7
loc nvarchar 55
ucode nvarchar 20
rwby nvarchar 30
disp nvarchar 55
Narrative ntext 16
Table2
ID int 4
nincident nvarchar 50
ncompl nvarchar 50
nfilename nvarchar 25
narr ntext 16
I used these 2 statements to narrow each table down to matching
filenames:
Select *
INTO TABLE1b
from table1
where exists(select * from table2 where
table1.filename = table2.nfilename)
SELECT *
INTO TABLE2b
FROM table2
WHERE exists(select * from table1 where
table1.filename = table2.nfilename)
My issue now is how to copy the narr field in table2 and insert it in
the Narrative field in table1 where table1.filename = table2.nfilename.
For every matching filename and nfilename(both are the keys) I need to
pull the narr field from table2 and insert it into Narrative in
table1. Does this make sense? Any assistance is greatly appreciated