Re: [SQLObject] DISTINCT and COUNT

[David M. C. <da...@da...>]

On Tue, Sep 14, 2004 at 04:58:40PM -0700, David M. Cook wrote:

> SELECT id FROM composer WHERE id IN (SELECT composer_id FROM work)

Got it!

r = Composer.select(IN(Composer.q.id, [SQLBuilder.Select(Work.q.composerID)]))

In [87]: r.clause
Out[87]: (composer.id IN (SELECT work.composer_id FROM work))

In [88]: r.count()
Out[88]: 1420

Dave Cook