Advertisement
egyware

Untitled

Sep 15th, 2015
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. UPDATE VEPRCART
  2. SET ve_lis_pesos = P1.ve_lis_pes
  3. FROM VEPRCART AS P2
  4. INNER JOIN DATA_1000.super_gc.GCPRCART AS P1 ON (P1.Mb_Epr_cod = P2.MB_Epr_cod AND P1.Ve_lista_p = P2.Ve_lista_precio AND P1.Art_cod =  P2.Art_cod AND P1.ve_lis_des = P2.ve_lis_desde)
  5. WHERE P1.Mb_Epr_cod = 'ARI' AND P1.ve_lista_p = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement