update one table with another with a where clause

[rust]

Hi All,

using ACCESS 2000 what I want to do is:

UPDATE A SET
A.gACID = (Select G.actionID from G
where A.PID = G.PID
and not G.Flg = true);

Of course I'm using ACCESS so I need to do something like

UPDATE A inner join G on
A.PID = G.PID
where not G.Flg = true

But it wont accept the where clause - But I need the where clause cause there may be many with the G.Flg = True but only one with the G.Flg = False

Thanks for any help

 

[tracy1234]

How about:

where G.Flg != true

or

where G.Flg <> true

-Tracy

 

[rust]

Thanks for replying I actually did get it to work
Have a deadline in an hour so I rushed a little THE SET GOES BEFORE THE WHERE


UPDATE A INNER JOIN G ON G.PID=A.PID SET A.GID = G.myID
WHERE Not G.Flg =True;