Advertisement
campocreek

Untitled

Nov 21st, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. INSERT INTO migrate.PA_DR (pd_pa_id, pd_dr_id, pd_ga_id)
  2. SELECT pa.id AS 'pd_pa_id', dr.id AS 'pd_dr_id', la.productid AS 'pd_ga_id'
  3.  
  4. FROM tecdoc_2016q1_europe.LINK_ART_GA_2017 la
  5.  
  6. INNER JOIN prices_all pa ON la.LAG_ART_ID = pa.pa_art_id
  7. INNER JOIN dok_ga dga ON la.productid = dga.GA_ID
  8. INNER JOIN dok_razdel dr ON dga.parent_id = dr.id
  9.  
  10. GROUP BY pa.id, dr.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement