There are no NULL values in either of the columns (that was my first thought). The table structure is
TABLEA URN: VARCHAR(12) LINKURN: VARCHAR(12) [Links to TABLEB.ID] AMOUNT: DOUBLE PRECISION TABLEB URN: VARCHAR(12) VALUE: DOUBLE PRECISION so the query is SELECT A.AMOUNT, B.VALUE, A.AMOUNT/B.VALUE FROM TABLE1 A JOIN TABLE2 B ON A.LINKURN = B.URN
