Re: Need an SQL joining lesson

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

Sample data I ultimately expect to insert into the file (don't know how
well this will line up):

Cust   YYYYMM  Category    Sales   Credits
====   ======  ========   =======  =======
1234   201802     A        500.00    25.00
1234   201802     B       1500.00     5.00
1234   201802     D        400.00      .00
1234   201802     E           .00    50.00
1234   201802     F        370.00      .00
2001   201802     A        500.00      .00
2001   201802     B        285.00    47.00
2001   201802     C           .00     1.00
2001   201802     D        200.00      .00
2001   201802     E        500.00    37.50
5250   201802     A        375.00      .00
5250   201802     B        285.00    47.00
5250   201802     D       5000.00   450.00
5250   201802     E       1200.00    75.00
5250   201802     F       1500.00    37.50

See inline.


On Thu, Apr 12, 2018 at 4:19 PM, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

> You don't need the coalesce...but that's not the problem...
>
> Is there a category in CUSRBTMST?
Jeff:  No

> If not, is there a category master table somewhere?
Jeff:  Yes

> Rob's on the right track...give us some example data...also what are the
> PK's?
Jeff:  PK's?

I probably won't respond until tomorrow.  Leaving work soon to go to Honor
Flight training.  Taking my Dad next month.