potreboval by som nieco takeho ale toto nefunguje
potrebujem nakopirovat data z tabulky wbr do tabulky wsr
nevie niekto ako by sa to dalo?

markus napísal:

Kód: Vybrať všetko

update spt001a.ws_load_mstr wsr, 
	   spt001a.wb_loadbul_mstr wbr
	   
set  wsr.cde_whse = wbr.cde_whse,  
	 wsr.cde_dock = wbr.cde_dock
	 
where  wsr.cde_whse = ' ' and
   wbr.seq_loadbul = (
    select min(wsl.seq_loadbul)
    from  spt001a.ws_load_matl wsl
    where  wsl.cde_plant = wsr.cde_plant and
       wsl.id_load = wsr.id_load)

potreboval by som nieco takeho ale toto nefunguje
potrebujem nakopirovat data z tabulky wbr do tabulky wsr
nevie niekto ako by sa to dalo?

insert into wsr select * from wbr

takto by mal nejako vyzerat prikaz. dlhsie s databazami uz nerobim, nepamatam si presne.