I have that request
articles = model.Article.select(
model.Comment.q.id != None,
join = LEFTJOINOn(None, model.Comment,
model.Comment.q.articleID == model.Article.q.id),
orderBy='-created')
which is translated into
SELECT article.id, article.link, article.title, article.summary,
article.updated, article.rss_id, article.user_id, article.category_id
FROM article LEFT JOIN comment ON ((comment.article_id) =
(article.id)) WHERE ((comment.id) IS NOT NULL) ORDER BY created DESC
Since I am doing a LEFT JOIN it seems natural for me to have the
request returning the fields from both tables article and comment. How
can I have sqlobject returning the fields from both tables.
-fred
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
