jQuery Grid Plugin - jqGrid - Topic: trying to make sence of the jqgrid demo sql query.... http://www.trirand.com/blog/?page_id=393/help/trying-to-make-sence-of-the-jqgrid-demo-sql-query Simple:Press Version 5.7.5.3 dottedquad on trying to make sence of the jqgrid demo sql query.... http://www.trirand.com/blog/?page_id=393/help/trying-to-make-sence-of-the-jqgrid-demo-sql-query#p4202 Help http://www.trirand.com/blog/?page_id=393/help/trying-to-make-sence-of-the-jqgrid-demo-sql-query#p4202 I figured it out.  They are alias which helps for shorthand 🙂

]]> Wed, 28 Jan 2009 22:26:58 +0200 dottedquad on trying to make sence of the jqgrid demo sql query.... http://www.trirand.com/blog/?page_id=393/help/trying-to-make-sence-of-the-jqgrid-demo-sql-query#p4201 Help http://www.trirand.com/blog/?page_id=393/help/trying-to-make-sence-of-the-jqgrid-demo-sql-query#p4201 Hello all.  Before I start to implement jqgrid I need to understand this sql query.

The demo calls for:

SELECT COUNT(*) AS count FROM invheader a, clients b WHERE a.client_id=b.client_id

Where it says : FROM invheader a, clients b WHERE a.client_id=b.client_id

what does a and b mean?

_thanks
]]> Wed, 28 Jan 2009 21:06:13 +0200