Frank Morton writes:
> If I do the query:
>
> select Content.* from Content,Protection
> where (Content.id = Protection.contentId);
>
> I get three rows back, corresponding to each group that has
> access to the content. However, I would like to get back
> just one row, corresponding to the content that fits the desired
> protections.
You didn't specify the "desired protection" anywhere within your query.
Possibly you want something like
SELECT * FROM content, protection WHERE content.id = protection.contentid
AND protection.name = 'something';
This will give you the content that "something" has access to, which may
be zero, one, or many rows.
--
Peter Eisentraut peter_e@gmx.net