update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '36K' ) where prodnum = '0037-A01'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '36K' ) where prodnum = '0038-A01'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '36K' ) where prodnum = '0039-A01'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '36E' ) where prodnum = '0180-02N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0180-02S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0180-05N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0182-02E'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = 'V12' ) where prodnum = '0182-02N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0182-02S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0182-05E'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0182-05N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0182-22N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0182-42E'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0182-45E'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0182-45N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0182-4BS'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0183-02E'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0183-02N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0183-183'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0183-42E'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12E' ) where prodnum = '0183-42N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '0275-011'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-11C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-11F'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-11P'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-11S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-11T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-11U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-11X'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-1EN'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-210'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-217'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-21C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12G' ) where prodnum = '1161-21F'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-21H'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-21P'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-21S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-21T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-21X'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-230'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-23A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-23F'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-23M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-23S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-23X'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-250'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-25A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-25C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-25F'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-25H'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-25K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-25M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-260'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-26A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-26C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-26K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-26M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-26T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-3MS'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-3MX'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-41A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-41F'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-41K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-41M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-41S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-41T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-41U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42H'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42J'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42P'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-42U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42X'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-42Y'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-43C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-43H'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-43K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-43P'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-43S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-43T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-43U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-43X'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-43Y'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-44U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-45U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-47N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-4AH'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-51S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-51U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-51X'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-52K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-52M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-52U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-57N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-61A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-61C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-61K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-61T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-61Y'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-62A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-62C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-62H'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-62K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-62T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-62U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-62Y'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-67N'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-71K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-71M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-71S'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-71U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-72A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-72J'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-86C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-91C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-91H'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-91K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-92A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-92C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-92H'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-92J'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-92K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-92M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-92T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-92U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-92Y'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-93C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-93F'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-93H'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-93K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-93T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-93U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-93Y'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-94H'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-94K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-94T'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1161-94U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-96A'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-96C'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-96K'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-96Y'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-9AK'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-EFH'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-HA1'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-HNM'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-HT1'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-HU1'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-I10'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-I11'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-I12'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-T1M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1161-WPM'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12G' ) where prodnum = '1171-1VU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-21U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-2AU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-310'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-330'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-340'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-350'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-370'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-4MU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-4UM'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-52J'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-5BU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-5CU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-5WJ'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-5WU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-5XM'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12G' ) where prodnum = '1171-5XU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-5YU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-61M'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-61U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-62J'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-6KU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-6LU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12G' ) where prodnum = '1171-6MU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-6XU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-71U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-72J'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-7GJ'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-7WJ'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-7WU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-7YU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-82J'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-8MU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-8XU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-91U'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-9AU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-9BU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-9KU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-9LU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '1EZ' ) where prodnum = '1171-9MU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-9WF'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-9WU'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-9XC'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-9XF'; update product.product set typewarrantyind = (select typewarrantyind from product.typewarranty where description = '12C' ) where prodnum = '1171-9XH'; update produ