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

Re: Access SQL Update Error

0 views
Skip to first unread message

santiago puñal pais

unread,
Nov 25, 2009, 4:14:47 PM11/25/09
to
 
"santiago puñal pais" <jac...@hotmail.es> escribió en el mensaje de noticias:...
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

david....@virginmedia.com

unread,
Feb 22, 2010, 2:38:36 PM2/22/10
to
 
"santiago puñal pais" <jac...@hotmail.es> wrote in message news:eQQCQ15b...@TK2MSFTNGP05.phx.gbl...
0 new messages