Thanks Duane,
At 30/04/2013 12:41 PM, you wrote:
>What are the primary and foreign keys?
I have not used the term foreign key before.
Primary key in ClubsEmail is 'ID"
Primary key in tClubs is "ClubID"
>If you change the query to a regular select query, can you update
>the tClubs.Email column?
No!
Robin Chapple
> > To: MS_Access_Professionals@yahoogroups.com
> > From: robinski@mymail.net.au
> > Date: Tue, 30 Apr 2013 10:08:35 +1000
> > Subject: [MS_AccessPros] Failed update query
> >
> > I have an update query that does not execute.
> >
> > Just one field is to updated from another table. it does not give an
> > error message and it foes not update!
> >
> > UPDATE ClubGmail LEFT JOIN tClubs ON ClubGmail.ClubName =
> > tClubs.ClubName SET tClubs.Email = [ClubGmail]![email];
> >
> > What have I missed?
> >
> > Many thanks,
> >
> > Robin Chapple
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar