Advertisement
Guest User

Untitled

a guest
Mar 26th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. elect
  2. a.DocEntry,
  3. a.CardName,
  4. a.Address,
  5. a.Address2,
  6. a.CardCode,
  7. a.TaxDate,
  8. b.Dscription,
  9. b.Quantity,
  10. b.Price,
  11. b.GTotal,
  12. b.WhsCode,
  13. c.WhsName,
  14. d.CompnyName,
  15. d.CompnyAddr,
  16. d.Phone1,
  17. e.U_NAME
  18. from OPOR a
  19. inner join POR1 b on a.DocEntry = b.DocEntry
  20. inner join OWHS c on a.DocEntry = c.WhsCode
  21. inner join OADM d on a.DocEntry = d.CompnyName
  22. inner join OUSR e on a.DocEntry = e.U_NAME
  23. where b.DocEntry = 36
  24. </code>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement