I have a payment journal table that is similar to the following:
ClientID Date Amount Category
123 1/2/01 -100 PMT
123 1/5/01 100 NSF
123 1/20/01 -35 PMT
I need to be able to find the first payment from each clientid that does NOT have a corresponding NSF (which will always be Amount *-1). I've tried to do this with a JOIN but I'm not having any luck.
ClientID Date Amount Category
123 1/2/01 -100 PMT
123 1/5/01 100 NSF
123 1/20/01 -35 PMT
I need to be able to find the first payment from each clientid that does NOT have a corresponding NSF (which will always be Amount *-1). I've tried to do this with a JOIN but I'm not having any luck.
Comment