Search results

  1. P

    Linked delete query with a Max

    Hi there I have a delete query where i want to delete only the row that contains the max value of the IDnum field from the table STM, where it links two tables on CellTell I currently have this: DELETE DISTINCTROW STM.*, STM.IDNum FROM dpl_00c_tbl_StmCellDups INNER JOIN STM ON...
Back
Top Bottom