Advertisement
Guest User

Untitled

a guest
Mar 31st, 2020
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select s.commoninfoikz,a.turchaseikz281119231879261,ts.ikz,t.purchasespurchaseikz
  2. FROM eis_plangraphs2020_44 as a
  3.    LEFT JOIN eis_plangraphs2020_44_positions_position as s on a.acgz_id = s.eis_plangraphs2020_44_id
  4.      LEFT JOIN talpurchase17204729971693 as t ON t.eis_plangraphs2020_44_id = a.acgz_id
  5.      LEFT JOIN ts_purchase089852881086955 as ts ON ts.eis_plangraphs2020_44_id = a.acgz_id
  6.    where a.plannumber='202003722001190001' and (a.versionnumber)::integer = 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement