| Subject | Dividing one column by another |
|---|---|
| Author | Russell Weetch |
| Post date | 2016-12-09T18:26:24Z |
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