| Subject | Re: [firebird-support] Dividing one column by another |
|---|---|
| Author | |
| Post date | 2016-12-12T11:05:30Z |
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.