Home Forums SQL Server 2012 SQL 2012 - General Lookup value from one table based on values in another table RE: Lookup value from one table based on values in another table

  • July 30, 2016 at 4:24 pm

    #1892779

    Maybe something like this?

    UPDATE [Table2]

    SET [CCode] = Table1.[CCode]

    WHERE [Table1].[TransType] = [Table2].[TransType]

    AND [LocID] Like '%' + [Table2].[Location] +'%');