Hi, I've read through the manual and the Cookbook, and found some details about how to use a left outer join with count, but don't understand how to use it correctly. I'm hoping that if I post some SQL that does what I want, that someone can translate it to Web2Py code for me. Despite mentioning the left outer join, I'm really after an inner join, but can't find any reference to it regarding count with web2py. SQL as follows: SELECT COUNT(AssetTable.TypeID) FROM AssetTable INNER JOIN TypeTable ON AssetTable.TypeID=TypeTable.id WHERE TypeTable.TypeID='Desktop';
Thanks. --James -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
