Re: Subqueries in the FROM Clause

On 18 April 2011 20:19, Joerg Bruehe wrote: > Hallo everybody! > > > Ants Pants wrote: > > 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 pled

Re: Subqueries in the FROM Clause

Hallo everybody! Ants Pants wrote: > 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 an

Subqueries in the FROM Clause

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