Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- elect
- a.DocEntry,
- a.CardName,
- a.Address,
- a.Address2,
- a.CardCode,
- a.TaxDate,
- b.Dscription,
- b.Quantity,
- b.Price,
- b.GTotal,
- b.WhsCode,
- c.WhsName,
- d.CompnyName,
- d.CompnyAddr,
- d.Phone1,
- e.U_NAME
- from OPOR a
- inner join POR1 b on a.DocEntry = b.DocEntry
- inner join OWHS c on a.DocEntry = c.WhsCode
- inner join OADM d on a.DocEntry = d.CompnyName
- inner join OUSR e on a.DocEntry = e.U_NAME
- where b.DocEntry = 36
- </code>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement