t; +-+
> > | sum(donation_pledge) - paid_donation_pledge |
> > +-+
> > | 22270 |
> > | 5924 |
> > +---
between
the subquery and the other tables. This would explain why the 70 is
subtracted not only from the BRL value but also from the EUR.
Off-hand, I have no explanation for the doubling of the sums, but I have
never used subqueries in the FROM clause.
Others might know more about this, but tellin
Hello All,
Tables:
# relevant fields
invitations: donation_pledge, paid (boolean), currency_id
currencies: code
I am trying to subtract the paid amounts from the amounts pledged using a
subquery in the FROM clause but am having problems and am going blind. Plus,
My SQL is weak at present.
I was
