Re: [sqlite] JOIN (SELECT o.pid, SUM(o.qty) 'qty_sold' FROM ORDERS o) qs

On Wed, Sep 16, 2009 at 9:50 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Gert Cuykens <gert.cuyk...@gmail.com> > wrote: >> On Wed, Sep 16, 2009 at 8:26 PM, Igor Tandetnik >> <itandet...@mvps.org> wrote: >>> Gert Cuykens <gert.cuyk...@gmail.com&

Re: [sqlite] JOIN (SELECT o.pid, SUM(o.qty) 'qty_sold' FROM ORDERS o) qs

On Wed, Sep 16, 2009 at 8:26 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Gert Cuykens <gert.cuyk...@gmail.com> > wrote: >> On Wed, Sep 16, 2009 at 1:35 AM, Igor Tandetnik <itandet...@mvps.org> >> wrote: > >>> Perhaps your query could be a b

Re: [sqlite] JOIN (SELECT o.pid, SUM(o.qty) 'qty_sold' FROM ORDERS o) qs

On Wed, Sep 16, 2009 at 1:35 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > Gert Cuykens <gert.cuyk...@gmail.com> > wrote: >>   SELECT t.pid, >>          t.txt, >>          t.price, >>          t.qty - IFNULL(qs.qty_sold, 0) 'onhand_qty' >>

[sqlite] JOIN (SELECT o.pid, SUM(o.qty) 'qty_sold' FROM ORDERS o) qs

SELECT t.pid, t.txt, t.price, t.qty - IFNULL(qs.qty_sold, 0) 'onhand_qty' FROM PRODUCTS t LEFT JOIN (SELECT o.pid, SUM(o.qty) 'qty_sold' FROM ORDERS o) qs ON qs.pid = t.pid WHERE t.pid = ? i have trouble running this

Re: [sqlite] 'UPDATE shop_orders SET comments=comments||? WHERE oid=?', ('test', '1')

thanks On Tue, Jan 20, 2009 at 5:54 PM, Hoover, Jeffrey wrote: > if comments is null then comments||? is also null, try this: > > comments=coalesce(comments,'')||? > ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] 'UPDATE shop_orders SET comments=comments||? WHERE oid=?', ('test', '1')

How do i do the following ? comments=comments||? When I add a comment nothing happens ? (please reply to my email address no subscription) ___ sqlite-users mailing list sqlite-users@sqlite.org