Results 1 to 6 of 6

Thread: Problem with update query (RESOLVED)

Threaded View

  1. Dec 10th, 2008, 01:24 PM #1
    MikeGarvin
    MikeGarvin is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    Europe
    Posts
    289

    Problem with update query (RESOLVED)

    Hi

    I am trying to build an update query but keep getting an error that says the column TableB.FirstName does not exist:

    update TableA set TableA.emailaddress = TableB.emailaddress where
    TableA.firstname = TableB.FirstName and TableA.lastname = Tableb.lastname

    Any ideas? Many thanks.

    Mike
    Last edited by MikeGarvin; Dec 10th, 2008 at 02:25 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width