Writing query containing ORPC, OPCH and OPOR

Jim Bo

Dec 13, 2017 at 08:23 PM | 103 Views | Last edit Dec 13, 2017 at 08:24 PM 2 rev.

I need to write a query containing the following on each line:

1. The DocNum of each ORPC, OPCH and OPOR,

2. The NumAtCard from OPCH

3. The DocTotal from OPCH / ORPC or from OPOR if OPCH does not yet exist.

Is this possible?

SQL

Sort by:

Find Questions & Answers