Re: Need an SQL joining lesson

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.