CursorA
cCode cName nRate
0001 John 10/90
0002 Mike 20/80
0003 Calvin 20/80
CursorB
cCode cName yCharges
0001 John 150.00
0002 Mike 80.00
0004 Jeff 120.00
Expected Result:
cCode cName nRate yCharges
0001 John 10/90 150.00
0002 Mike 20/80 80.00
0003 Calvin 20/80 0.00
0004 Jeff 120.00
Pls advise