"update ta set ta.ra=1 from tablename ta" how can pass in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lll-j - 01 Nov 2007 15:51 GMT

is it can be pass in the Access?
how to change?
thanks!

update ta
set col = t.col
from ta,(select id,max(col) col from tb
group by id) t
where ta.id = t.id

Reply to this Message

Michel Walsh - 01 Nov 2007 16:38 GMT

UPDATE ta SET col = DMAX("col" , "tb", "id=" & id )

or (untested)

UPDATE ta INNER JOIN tb ON ta.id=tb.id
SET ta.col = tb.col
WHERE tb.col = ( SELECT MAX(col) FROM tb AS c WHERE c.id = ta.id )

A Jet query implying an aggregate (elsewhere than in a sub-query in the
WHERE clause) is NOT updateable.

Vanderghast, Access MVP

> is it can be pass in the Access?
> how to change?
[quoted text clipped - 5 lines]
> group by id) t
> where ta.id = t.id

Reply to this Message