Hello All,
I am using Toad 11.6, I am not sure if my subject really clarifies what I need assistance with. I am not able to join (if that is the correct solution) the view data below. The record that has the 98.38 value should display within the other records and the record with that value should not display. Can anyone assist me with this, thanks for reading also.
SELECT SID,
ORGANIZATION_ID,
ORGANIZATION,
PERMIT_NUMBER,
GAME_DATE,
BASIS_FOR_FEE,
ADDAMOUNT,
CHGSDESC,
PBPAYAMT
FROM ABCGAMING_PRE_POSTING_VW
WHERE ORGANIZATION = 'Bombers Test'
SID ORGANIZATION_ID ORGANIZATION PERMIT_NUMBER GAME_DATE BASIS_FOR_FEE ADDAMOUNT CHGSDESC PBPAYAMT
247741 243480 Bombers Test 644 3/3/2014 865 0 0
247750 243480 Bombers Test 644 0 0 98.38
247740 243480 Bombers Test 644 3/6/2014 162.5 0 0
I would like the results to look like below, the PBPAYAMT and CHGSDESC should display within the other records. But also remove the extra record with no Game Date, Basis For Fee, and Addadmount values.
SID ORGANIZATION_ID ORGANIZATION PERMIT_NUMBER GAME_DATE BASIS_FOR_FEE ADDAMOUNT CHGSDESC PBPAYAMT
247741 243480 Bombers Test 644 3/3/2014 865 0 98.38
247740 243480 Bombers Test 644 3/6/2014 162.5 0 98.38