W3C home > Mailing lists > Public > public-webapps@w3.org > April to June 2010

Re: [IndexedDB] Proposal for async API changes

From: Shawn Wilsher <sdwilsh@mozilla.com>
Date: Wed, 19 May 2010 14:03:41 -0700
Message-ID: <4BF4522D.6030606@mozilla.com>
To: Jonas Sicking <jonas@sicking.cc>
CC: Webapps WG <public-webapps@w3.org>
On 5/19/2010 1:50 PM, Shawn Wilsher wrote:
Er, and I managed to botch the SQL in the last two examples.  Those 
should be (if my non-tested SQL-fu is right):
SELECT name, COUNT(kids.id)
FROM kids INNER JOIN candySales
ON kids.id = candySales.kidId
GROUP BY kids.id;

and:
SELECT name, COUNT(kids.id)
FROM kids LEFT JOIN candySales
ON kids.id = candySales.kidId
GROUP BY kids.id;

respectively.

Cheers,

Shawn



Received on Wednesday, 19 May 2010 21:01:49 GMT

This archive was generated by hypermail 2.3.1 : Tuesday, 26 March 2013 18:49:38 GMT