The links aren't on the double precision fields, they are on the VarChar(12) link fields.
The query does return rows and shows the AMOUNT from Table A and the VALUE from Table B. All of which have values. It is the calculated field (A.AMOUNT / B.VALUE) that returns null.
