> update accountinfo set typ='SERVER' where deviceid in (select BIOS.deviceid from BIOS,accountinfo where accountinfo.deviceid=bios.deviceid and SMODEL like 'Power%' and typ is null);
ERROR 1093 (HY000): You can't specify target table 'accountinfo' for update in FROM clause
co zrobic aby jednak accountinfo.typ dostalo swoja wartosc ? (oracl i mssql ponoc lyknalby ta skladnie)