Re: help in formatting a query

[Tyler Hains]

I'm not 100% clear on what you're trying to accomplish, but I think you can do what you want with a join and use of 'OR'. You may want to start with something like this:

select a.* from article a left join audience_members m on (a.article_id = m.article_id and m.member_id = '$currentUserID')
where a.submitter_id = '$currentUserID'
OR ( a.audiencescope = 2 AND m.member_id in ('2', '4', '6'))

Hope this helps,
Tyler