Advertisement
Guest User

Untitled

a guest
May 26th, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. select t01.a2arti , t04.ardesc, t04.ardsce, t05.trnome, t02.dapprd, t02.daputs, t02.daputi, t02.dadese, t09.danuma, t10.ardesc as caixa, t13.ardesc as filme, t03.aculot, t03.aclotc, t03.acundc, t01.azqref, t03.acebas, t03.acealt, t03.acepal, t02.daaltc, t08.ardesc as palete from eplbf01.epart2f as t01 join eplbf01.epxdapf as t02 on t01.a2marc = t02.damarc and t01.a2arti = t02.daarti join eplbf01.epxacdf as t03 on t02.dacoda = t03.accoda join sklbf01.skartif as t04 on t01.a2marc = t04.armarc and t01.a2arti = t04.ararti join gllbf01.gltercf as t05 on t04.arforn = t05.trcodi join eplbf01.epligaf as t06 on t01.a2marc = t06.lgmrc1 and t01.a2arti = t06.lgart1 and '' = t06.lgvrs1 join eplbf01.epligaf as t07 on t07.lgmrc1 = t06.lgmrc2 and t07.lgart1 = t06.lgart2 and (left(t07.lgart2,2) = '45' or left(t07.lgart2,3) = '145' ) join sklbf01.skartif as t08 on t08.armarc = t07.lgmrc2 and t08.ararti = t07.lgart2 join eplbf01.epversf as t09 on t01.a2marc = t09.vrmarc and t01.a2arti = t09.vrarti and '' = t09.vrvers join eplbf01.epligaf as t10 on t10.lgmrc1 = t06.lgmrc2 and t10.lgart1 = t06.lgart2 and left(t10.lgart2,4) = '4416' join sklbf01.skartif as t11 on t11.armarc = t10.lgmrc2 and t11.ararti = t10.lgart2 join eplbf01.epligaf as t12 on t12.lgmrc1 = t06.lgmrc2 and t12.lgart1 = t06.lgart2 and left(t12.lgart2,4) = '4433' join sklbf01.skartif as t13 on t13.armarc = t12.lgmrc2 and t13.ararti = t12.lgart2 where t01.a2marc = '%MARCA%' and t01.a2arti = '%ARTIGO%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement