Update Query using inner join with a linked table

access United States
  • 13 years ago

    I have a text file that is linked my database. What I'm trying to do is update another with the data from this linked file using an inner join.

    I get the error message 'Updating linked table is not supported by this ISAM'. BUT I am not updating the linked file I am updating the other table, is there a way to work around (please keep in mind performance is everything)

    Linked file: IIB_XREF
    Other table: GRID_XREF

    Query:

    UPDATE GRID_XREF
    INNER JOIN IIB_XREF2 ON IIB_XREF2.ALTERN_CODE = GRID_XREF.ALTERN_CODE 
    SET GRID_XREF.GRID_ID = IIB_XREF2.GRID_ID
    WHERE IIB_XREF2.GRID_ID<>GRID_XREF.GRID_ID;


    Anyone ?

















  • 13 years ago
    Do not use join try:

    Update T1, T2 On T1.x = T2.x Set T1.val = T2.val



Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Measuring programming progress by lines of code is like measuring aircraft building progress by weight.” - Bill Gates