Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    15

    Unanswered: have a problem with the left function in a join

    UPDATE [All] INNER JOIN [tbl location] ON (Left([tbl location].[Name],5)=left([All].[Name],5)) SET [All].[Primary] = [tbl location].[primary];


    It just stops after a bit when trying to update. I have two tables "tbl location" and "All" on tbl loacation.name i have some fields that I want to compare the first five letters of All.name where if the first five characters in all match to the first five in location it will join.

    Stops after the first few ticks on the progress bar.

    Any suggestions?

  2. #2
    Join Date
    May 2003
    Posts
    144
    Is the column "Primary" your primary key?

  3. #3
    Join Date
    Jan 2004
    Posts
    15
    no its just a name short for primary dealer number.

  4. #4
    Join Date
    Jan 2004
    Posts
    15
    bump

Posting Permissions

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