Update data

[nDAa]

I am trying to Update multiple row for example :

Table1 : fld11 fld12
101 48A01
101 48A02
101 48A03
102 48A04
103 48A05
105 48A06
105 48A07
Table2 : fld21 fld22
48A01 'N'
48A02 'N'
48A03 'N'
48A04 'N'
48A05 'N'
48A06 'N'
48A07 'N'
I need my query to update like this :

UPDATE Table2
SET fld22 = 'R'
WHERE Table1.fld11 = '101'
Anyone have any suggestions ?

 

[jbenson001]

You have to Join the 2 tables on some key column.