Re: [SQLObject] DISTINCT and COUNT

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

On Tue, Sep 14, 2004 at 10:49:37AM -0500, Ian Bicking wrote:

> SELECT composer.all columns... FROM composer WHERE EXISTS (SELECT * FROM 
> work WHERE work.composer_id = composer.id);

Using IN works as well, and is probably more universal (tested in postgres
and sqlite)

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

Dave Cook