I have two tables connected. One is owners, the other is dogs. Let's say I'm listing owners with a nice SQLTABLE(db.owners).
Now I wanted to add a column in the generated table with the number of owned dogs db(db.dogs.owner == owner).count() so the end result would be SQLTABLE with an extra column. Is there an easy way to make this happen with SQLTABLE? Second, is there a way to change the displayed order of the SQLTABLE columns? Thank you, Best regards
