Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Access SQL Update Error

0 views
Skip to first unread message

MiRoT

unread,
Jul 20, 2009, 9:55:03 AM7/20/09
to
Hello.
I have this table named pelates
kwdikos_pelath --- primary key
hmeromhnia
poso_kefalaiou

and this table named updates
kwdikos_pelath
hmeromhnia
poso_kefalaiou

i tryed to update table pelates via table updates with this sql coed but i
got an error.

UPDATE pelates INNER JOIN updates
ON pelates.kwdikos_pelath=updates.kwdikos_pelath
SET pelates.hmeromhnia = updates.hmeromhnia,
pelates.poso_kefalaiou=updates.poso_kefalaiou;

Where is the problem in that code?
Thanks

AFSSkier

unread,
Sep 22, 2009, 6:13:03 PM9/22/09
to
MiRoT,

There isn't anything wrong with the code. It tested fine for me. What is
the error?

You could try this:


UPDATE pelates INNER JOIN updates ON pelates.kwdikos_pelath =

updates.kwdikos_pelath SET pelates.hmeromhnia = [updates]![hmeromhnia],
pelates.poso_kefalaiou = [updates]![poso_kefalaiou];

--
Kevin

JORGE

unread,
Sep 29, 2009, 5:29:46 AM9/29/09
to

"MiRoT" <Mi...@discussions.microsoft.com> wrote in message
news:2A078D45-F8F5-4B16...@microsoft.com...

Laoshu

unread,
Oct 20, 2009, 7:26:08 AM10/20/09
to

"AFSSkier" <AFSS...@discussions.microsoft.com> 写入消息
news:88100F5D-E9EA-417E...@microsoft.com...

Ata Kemal

unread,
Nov 6, 2009, 3:08:22 PM11/6/09
to

"AFSSkier" <AFSS...@discussions.microsoft.com>, iletide şunu yazdı
news:88100F5D-E9EA-417E...@microsoft.com...

Ata Kemal

unread,
Nov 7, 2009, 8:51:49 AM11/7/09
to

"AFSSkier" <AFSS...@discussions.microsoft.com>, iletide şunu yazdı
news:88100F5D-E9EA-417E...@microsoft.com...

Ata Kemal

unread,
Nov 14, 2009, 3:20:10 AM11/14/09
to

"Ata Kemal" <atak...@windowslive.com>, iletide şunu yazdı
news:D7F37B15-A36B-4645...@microsoft.com...

0 new messages