-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Try one of these:
DELETE DISTINCTROW History.*
FROM History INNER JOIN [History LatestUpdateDate] ON
HIstory.weekupdated = [History
LatestUpdateDate].MaxOfweekupdated;
OR
DELETE *
FROM History H
WHERE weekupdated EXISTS
(SELECT * FROM [History LatestUpdateDate]
WHERE MaxOfweekupdated = H.WeekUpdated)
JET SQL is finicky about updateable queries in DELETE & UPDATE queries.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQfXamYechKqOuFEgEQIYwwCg4/NKkTEyLHn/DiLDPG1qAD9Z5s4AoKE6
x67wp6cG7supMaQwX6hr//g3
=6qVa
-----END PGP SIGNATURE-----
John Baker wrote:
Thanks:
This is what it looks like now:
DELETE History.*
FROM History INNER JOIN [History LatestUpdateDate] ON History.weekupdated = [History
LatestUpdateDate].MaxOfweekupdated;
I get the error "Could not delete from specified tables". I guess I am still doing
something wrong, but dont know what!
John!
MGFoster <me@privacy.com> wrote:
DELETE A.*
FROM A INNER JOIN B ON A.ID = B.ID
Put the A.* (table_name.*) as the only column in the design grid.