Update Query using inner join with a linked table

• • Reply

  13 years ago

  by ceekay

  ceekay

  , United States

  Joined 16 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 ?
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Report abuse
• • Reply

  13 years ago

  by konikula

  Matej Kasper

  Trutnov, Czech Republic

  Joined 15 years ago
  Do not use join try:
  
  Update T1, T2 On T1.x = T2.x Set T1.val = T2.val
  
  
  
  
  Report abuse