select * from productosgeneral where idfabricante=(select * from fabricantes where fabricante="ABB") delete from productosgeneral where cod_producto="10677"