[firebird-support] Dividing one column by another

[Russell Weetch russ...@smxi.com [firebird-support]]

I am trying to divide one column in table A by another in table B, but it
just gives me null values. The query is

SELECT A.AMOUNT, B.VALUE, A.AMOUNT/B.VALUE
FROM TABLE1 A
JOIN TABLE2 B ON A.URN = B.URN

any ideas gratefully received.

Russell