Re: how to restrict inner results in OUTER JOIN?

On Mon, 5 May 2003 21:40:10 -0700, Drew Wilson <amw@speakeasy.net>
wrote:
>I'm trying to use a left outer join to remove rows my user doesn't have
>access permission to see.

        SELECT * FROM foo f LEFT OUTER JOIN secure_group sg
                 ON (f.group_id = sg.group_id AND sg.group_id = 1);

Servus
 Manfred